What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.
- A . Use Schema for the Connections
- B . Maintain, Monitor and test secondary database connection
- C . Maintain only HANA specific objects
- D . Used to access local or remote database system
The source code editor in ADT provides many helpful features.
What are these helpful features? There are 2 correct answers to this question.
- A . Creating Method Implementations from the Method Definition
- B . Creating interface from Method Calls
- C . Creating Method Definitions from Implementation Parts
- D . Creating Parts for Interface Methods
What are the purposes of tools in SAP HANA system that is an Eclipse-based integrated development environment? There are 3 correct answers to this question.
- A . Organizing
- B . Administer
- C . Configure
- D . Monitor
- E . Selecting
One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration.
What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.
- A . Direct access to a cluster on the database
- B . Left outer joins in open SQL statements
- C . Native SQL statements
- D . Code that relies on implicit database sorting
- E . ORDER BY Clauses in Open SQL statements
You want to debug an ABAP program using ABAP development tools (ADT).
How do you launch the debugger? Please choose the correct answer.
- A . Choose the debug as option in the context menu of the ABAP program
- B . Create a debug configuration for the ABAP application and run the program
- C . Set a breakpoint in the ABAP program and execute the program
- D . Choose the Run –> Debug options in the menu
When would you use a column store table instead of a row store table? There are 2 correct answers to this question.
- A . When you require aggregation and analysis of values
- B . When the table has a small number of records
- C . When there are mainly distinct values in the table
- D . When you want to enable a full-text-search of the table
To upload data from flat files, SAP HANA offers several features.
What are these important features? There are 2 correct answers to this question
- A . The application suggests the column name and data type for the new tables, and it is possible to edit them
- B . The supported file types for upload are: .cssv, .xlls, and .xlsxxx
- C . The new table always has a 2:2 mapping between the file and table columns
- D . When loading new data in the table, it gets appended to the existing data
Which features does the source code editor provide in ABAP Development Tools (ADT)? There are 2 correct answers to this question.
- A . Quick Fix
- B . Screen Painter
- C . Content Assist
- D . Form-based Class Builder
You created and activated database procedure.
How can you call this procedure? There are 2 correct answers to this question.
- A . By another database procedure
- B . By using Sap Analysis for Microsoft office
- C . By a script-based calculation view
- D . By a core data services view
What all are the advantages provides by ABAP Development Tools? There are 3 correct answers to this question.
- A . A set of open, language- and platform-independent APIs
- B . A brand new ABAP development experience on top of the Eclipse platform
- C . An open platform for developing new ABAP-related tools
- D . An open platform for developing powerful database view
- E . A set of Eclipse data pool and Client- Open platform
When are referential joins executed in analytical views? Choose the correct answer
- A . When all the tables are optimized
- B . When fields are selected
- C . When fields are optimized
- D . When fields from both the tables are requested
Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? There are 2 correct answers to this question.
- A . Partitioning
- B . Database table compression
- C . Column data storage
- D . Parallel processing
Which is the new concept that is introduced and improved by using SAP HANA Specific Features? Please choose the correct answer.
- A . Programming model
- B . Table buffering
- C . New advanced SQL syntax Procedures
- D . ABAP-Managed Database Procedures
What made SAP HANA possible?
- A . There are 2 correct answers to this question.
- B . Improved hardware technology
- C . CPU with single core network
- D . RAM limitation
- E . Technology and innovations
When to use Enhanced Open SQL? There are 2 correct answers to this question.
- A . To view scalar components
- B . At the time of Dictionary Views
- C . Need the query in one piece of code only
- D . To access system fields
Name the views that are available to administer and monitor one or several SAP HANA systems? There are 2 correct answers to this question
- A . The Landscape view
- B . The System Monitor view
- C . The Security view
- D . The Administration view
You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method Y.
What pattern of gross and net run time would you expect to see the in the ABAP trace results for method X? Please choose the correct answer.
- A . The gross and net run times are identical
- B . The net run time is less than the gross run time
- C . The net run time is equal to Zero
- D . The net run time is greater than the gross run time
Which of the following are view annotations for a CDS view? There are 3 correct answers to this question.
- A . Semantics
- B . Client handling
- C . Buffering type
- D . Environment
- E . Access control
What are the Parameters for Analytical and Calculation view? There are 3 correct answers to this question.
- A . Specifying unit of measurement
- B . Passing other values to be used in calculations
- C . Create a copy of a report
- D . To store data for critical analysis
- E . Setting a filter for columns
What is the purpose of an ABAP project in ABAP Development Tool for eclipse? There are 2 correct answers to this question
- A . It represents the connection to an ABAP System
- B . It provides access to all ABAP repository objects in an ABAP system
- C . It represents the connection to the SAP HANA Layer
- D . It is used to transport the ABAP repository Objects.
Which of the following is not involved in database table of "The NewABAP SQL Monitor-Architecture? Choose the correct answer
- A . Selection data table
- B . Performance data table
- C . Critical data table
- D . Runtime monitor data
Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)? There are 3 correct answers to this question.
- A . Returning
- B . Receiving
- C . Exporting
- D . Changing
- E . Importing
Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.
- A . Get all the data you need on the application server and do your processing in ABAP
- B . Creating and consuming all the contents from network
- C . Keep load from the database
- D . Collect all the data and perform Parallel processing in ABAP
Which code-to-data capability is responsible for the Optimizations & Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL? Please choose the correct answer.
- A . Database Optimization
- B . Transparent Optimizations
- C . HANA Specific features
- D . Buffer system Optimization
What are the two types of editors available in ADT? There are 2 correct answers to this question.
- A . Eclipse (native)
- B . Client (native)
- C . SAP (GUI)
- D . ABAP (native)
Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.
- A . Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement
- B . Use array variants of INSERT UPDATE MODIFY and DELETE
- C . Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES
- D . Perform all calculations and aggregations in the ABAP layer
The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.
- A . Avoid idiling CPU cores
- B . Avoid CPU cache misses
- C . Avoid optimizing data
- D . Avoid single network
Discuss the conditions required to ensure the Referential Integrity? There are 2 correct answers to this question
- A . There are three joins in the table
- B . Referential integrity holds true in both the directions
- C . There is at least one join in the other table
- D . There are two joins in the table
What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.
- A . Process on all the input fields
- B . Automatic updates of all the input fields
- C . Check Pre-Requisites
- D . Identify Elementary Search Help
- E . Switch on proposal search for input fields
Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Please choose the correct answer.
- A . Combine information from static ABAP code scans with runtime data from the SQL Monitor.
- B . Create a graph comparing the runtimes of ABAP code before and after optimization.
- C . Estimate the new total runtime of optimized code.
- D . Combine information from static ABAP code scans with runtime data from the SQL Trace tool.
The SAP HANA state-of-the-art search experience includes full-text search with advanced features like… There are 3 correct answers to this question.
- A . ACID search
- B . Freestyle search
- C . Isolation search
- D . Fuzzy search
- E . Linguistic search
In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog?
Which of the following table types fulfill this requirement? Please choose the correct answer.
- A . ROW
- B . GLOBAL TEMPORARY
- C . COLUMN
- D . LOCAL TEMPORARY
ABAP 7.4 provide support for optimizing ABAP applications running on SAP HANA.
What are these transparent optimizations? (3 ans)
- A . Performance analysis tools have been improved
- B . Do all the data processing in Application server
- C . The consumption of SAP HANA artifacts was simplified
- D . Re-use components have been extended or optimized for SAP HANA
- E . The ABAP language and the Open SQL language have been extended
Which of the following is a limitation when you create an external view? Please choose the correct answer.
- A . You must include the name of the SAP HANA view in the name of the external view.
- B . You can only use native SQL to consume the external view
- C . You must know the underlying tables and join conditions of the SAP HANA view.
- D . You must use the ABAP Development tools (ADT) TO CREATE the external view
What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question
- A . Fewer data duplication and movement
- B . Exploit structured contents in SQL
- C . Easy to use modeling tool
- D . Large number of toolkits are available
You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call? Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.
- A . SET_PARAM_TABLE
- B . SET_PARAM
- C . EXECUTE_QUERY
- D . NEXT_PACKAGE
You made changes to an object (X) used by an ABAP managed database procedure (AMDP). You did NOT changes the AMDP itself. Now you execute a program that calls this.
In which cases does the call trigger the creation of the database procedure in SAP HANA? There are 2 correct answers to this question.
- A . X is a stored procedure.
- B . X is an SAP HANA view
- C . X is an ABAP Dictionary table
- D . X is an AMDP method
How to create a core data services view? (3 ans)
- A . Use SQL capabilities for Netweaver
- B . Use data services tools for updates
- C . Use DDL statement DEFINE VIEW and SQL like syntax to define the view
- D . Use the ABAP Development Tools for SAP Netweaver
- E . Use additional annotations – marked with the @sign
What are the elements of ABAP Database Integration? There are 3 correct answers to this question.
- A . Client database handling
- B . Application server
- C . DB client-server
- D . Other DB
- E . DB For ABAP
You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question.
- A . CASTE Expression
- B . CASE expression
- C . Currency Conversion
- D . Nested CASE expression
- E . Unit conversion
You create a new table definition using the ABAP Dictionary and maintain the database-specific technical settings table?
Why do you create a row store instead of a column store Please choose the correct answer?
- A . To allow creation of a full-text index
- B . To limit the unpacking and reconstruction of rows
- C . To limit the need of indexes
- D . To limit the data footprint
In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? Please choose the correct answer.
- A . Include all fields used in the ON condition in projection list
- B . Specify an alias for the target entity
- C . Define the cardinality for the target entity
- D . Specify the other views in which the association can be used
You developed an ABAP managed database procedure (AMDP). You want to allow the enhancement of this AMDP using business add-in (BADI).
Which of the following objects must you create? There are 3 correct answers to this question.
- A . A BADI definition
- B . A BADI fallback implementation
- C . An enhancement spot
- D . A database procedure
- E . A BADI simple implementation
SAP HANA DB Migration: you want to avoid any functional issues after the migration? There are 3 correct answers to this question.
- A . Native sql statement
- B . Direct access to a cluster on the database
- C . Left outer joins in open SQL statements
- D . Order by clause in open SQL statement
- E . Code that relies on implicit database sorting
What all are the factors involved in Working with ADT.
If the search options are enabled, you can set the search parameters for an attribute of a view, which parameters will be available? There are 3 correct answers to this question.
- A . ABAP interface
- B . Module interface
- C . Workbench programs
- D . ABAP programs
- E . ABAP Class
The SAP HANA database is a hybrid in-memory database that combines Few technologies within.
What are these technologies? There are 3 correct answers to this question
- A . Row-based database technology
- B . Time-based database technology
- C . Column-based database technology
- D . Object-based database technology
- E . Value-based database technology
You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA.
What do you have to do in the corresponding ABAP class? Please choose the correct answer.
- A . Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB.
- B . Implement the interface IF_AMDP_MARKER_HDB.
- C . Set the visibility of the corresponding class method in the declaration section to PUBLIC.
- D . Implement the ABAP AMDPJHDB Event Handler.
How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement? Please choose the correct answer.
- A . As many result sets as there are input parameters in the procedur
- B . Two result sets
- C . One result set
- D . As many result sets as there are table output parameters in the procedure
What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.
- A . Automatic release of units
- B . Changes to Delta Container
- C . You need to refresh the content of the container manually
- D . Take snapshot manually before releasing of the container
Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.
- A . ABAP Dictionary
- B . Open SQL
- C . Core data services (CDS) data definition
- D . Core data service (CDS) access control