1. What are the components of The Enterprise Procurement Model Demo Scenario?
There are 3 correct answers to this question. Stock Services Procurement Sales Product. 2. Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement.
Which of the following changes to the SELECT statement can you use to retrieve the same data as before?
There are 2 correct answers to this question. Use the CLIENT SPECIFIED addition Include the client field in the WHERE condition Include the client field in the field list Include the client field in the join condition. 3. Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”? Selection data table Critical data table Performance data table Runtime monitor data. 4. What are the two types of editors available in ADT? There are 2 correct answers to this question. Eclipse (native) SAP (GUI) Client (native) ABAP (native). 5. Open SQL largely standardized, three sub-languages. What are these sublanguages?
There are 3 correct answers to this question Data Evaluation Language(DEL) The Data Control Language (DCL) Data Manipulation Language (DML) Data Transferring Language(DTL) The Data Definition Language (DDL). 6. You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench? Please choose the correct answer. Code formatting options Code completion options Statement template options Editor shortcut key options. 7. ABAP 7.4 provides support for optimizing ABAP applications running on SAP HANA. What are these Transparent Optimizations? The ABAP language and the OpenSQL language have been extended Do all the data processing in Application server Re- use components have been extended or optimized for SAP HANA The consumption of SAP HANA artifacts was simplified Performance analysis tools have been improved. 8. What are the features of New Open SQL? There are 2 correct answers to this question. Supports specific units of database Supports Code adjustment model Supports conditional expressions Supports arithmetic and string expressions. 9. Which code-to-data capability is responsible for the Optimizations & Translation of “Open SQL SELECT FOR ALL ENTRIES “clauses into native SQL? Transparent Optimizations HANA Specific features Database Optimization Buffer system Optimization. 10. What are the two main methods to add a system to the SAP HANA Studio? There are 2 correct answers to this question By Resource console By Importing a Landscape Automatically Manually. 11. 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. Direct access to a cluster on the database Code that relies on implicit database sorting ORDER BY Clauses in Open SQL statements Native SQL statements Left outer joins in open SQL statements. 12. 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 BADI definition A database procedure A BADI simple implementation AN enhancement spot A BADI fallback implementation. 13. Which data provisioning methods can you use when you need real time replications?
There are 2 correct answers to this question. SAP Replication server SAP Data services SAP HANA Direct extractor connection (SAP DXC) SAP Landscape transformation Replication server (SAP SLT). 14. What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? There are 2 correct answers to this question. Automatic release of units Changes to Delta Container Take snapshot manually before releasing of the container You need to refresh the content of the container manually. 15. Which of the following are performance recommendations when using SAP HANA?
There are 2 correct answers to this question. Define indexes on the columns that are used in calculations. Filter data in lower layers. Move data-intensive calculations from the database to an application server. Avoid transferring large result sets between database and client applications. 16. 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 Value-based database technology Column-based database technology Row-based database technology Time-based database technology Object-based database technology. 17. Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer?
There are 2 correct answers to this question. Enhanced distribution of results Documented checks Flexible schedule of check runs Configuration of check variants. 18. Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)?
There are 3 correct answers to this question. SQL Trace (transaction ST05) Code inspector (transaction SCI) SQL monitor (transaction SQLM) Data base performance monitor (transaction DB50) ABAP test cockpit (transaction ATC). 19. Which of the following are characteristics of an external view?
There are 3 correct answers to this question. It can be used as a data type in ABAP programs. It can be used in Open SQL statements for database updates. It is an ABAP Dictionary object type. It defines the underlying SAP HANA information view. It allows access to an SAP HANA information view with Open SQL.