1. What are the steps involved in supporting a database oriented programming model? Core Data services Advanced and specific models A new and advanced Open SQL Buffer system services.
2. What are the steps that supported several tools, which in total result in a Guided Performance Optimization? Tools analyzing performance at run-time, to determine if critical constructs A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption A new tool called SQL Monitor to determine the priority if different programs access the database intensively.
3. Which of the following is a limitation when you create an external view? You must include the name of the SAP HANA view in the name of the external view You must use the ABAP Development tools (ADT) TO CREATE the external view You can only use native SQL to consume the external view You must know the underlying tables and join conditions of the SAP HANA view.
4. 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? Code formatting options Code completion options Statement template options Editor shortcut key options.
5. 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 ? LOCAL TEMPORARY COLUMN ROW GLOBAL TEMPORARY.
6. Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? Provisioning folder Content folder Administration folder Security folder.
7. Name the views that are available to administer and monitor one or several SAP HANA systems? The Security view The Landscape view The System Monitor view The Administration view.
8. You are implementing an ABAP Managed Database Procedures (AMDP) for SAP HANA.
What do you have to do in the corresponding ABAP class? Implement the interface IF_AMDP_MARKER_HDB. Set the visibility of the corresponding class method in the declaration section to PUBLIC. Declare the ABAP class as a sub-class of CL_AMDP_RUNTIME_HDB. Implement the ABAP AMDP_HDB Event Handler.
9. Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? Data base performance monitor (transaction DB50) SQL Trace (transaction ST05) ABAP test cockpit (transaction ATC) Code inspector (transaction SCI) SQL monitor (transaction SQLM).
10. 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 AMDP.
In which cases does the call trigger the creation of the database procedure in SAP HANA? X is a stored procedure X is an ABAP Dictionary table X is an SAP HANA view X is an AMDP method.
11. You define a core data services (CDS) view to merge the results of queries using the UNION keyword. What must the column list of this queries contain? The same number of columns Columns of identical types Columns of compatible types All key fields.
12. Which task can you perform with the SQL Performance Tuning Worklist tool (SWLT)? Combine information from static ABAP code scans with runtime data from the SQL Monitor. Estimate the new total runtime of optimized code. Combine information from static ABAP code scans with runtime data from the SQL Trace tool. Create a graph comparing the runtimes of ABAP code before and after optimization.
13. Which of the following tasks can you perform with SQL monitor (transaction SQLM)? Display the execution plan of an SQL statement Combine static and dynamic performance analysis results Capture the SQL profile of an application Search for problematic SELECT* statements.
14. Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)? Returning Changing Receiving Exporting Importing.
15. What are the basic principles of ALV SAP HANA? The ALV Optimization for SAP HANA to display data on the screen Only retrieve the database data which is to be displayed on screen To ensure that the user chooses the data on the selection screen is displayed Data described declaratively instead of passing big internal tables.
16. 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? Include the client field in the field list. Use the CLIENT SPECIFIED addition. Include the client field in the join condition. Include the client field in the WHERE condition.
17. What are the steps involved in SAP HANA Evolution? ABAP can run on SAP HANA ABAP as accelerator on SAP HANA Optimized ABAP on SAP HANA ABAP can access SAP HANA ABAP applications on SAP HANA.
18. What are the Possible Approaches with AS ABAP < 7.4 SP02 ? SQL units Consume using native SQL Interaction with Database Stored Procedures.
19. Which of the following is not an element of Analytical view? Read Data from the joined database tables Used to Joined table Currency conversion is not applicable Join fact tables.
20. What are the Parameters for Analytical and Calculation view? Setting a filter for columns Passing other values to be used in calculations Create a copy of a report Specifying unit of measurement.
21. Discuss the conditions required to ensure the Referential Integrity? Referential integrity holds true in both the directions There are two joins in the able There is at least one join in the other table There are three joins in the table.
22. ANSI SQL owns features and adds languages these languages divided into three parts. What are they? The Data Control Language Data Manipulation Language The Data Definition Language Data Transferred Language The Database Language.
23. In addition to closing the result set, what does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Update resources Update packages Release packages Release resources.
24. DB-Specific Properties that allows switching between storage types when running on an SAP HANA database.
What are these storage types? Re-use component store Column store ROW store Technology store Development Store.
25. What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question. Eliminate nested SELECT statements to reduce the overall number of database accesses Calculate aggregations using ABAP code on the application server to limit database load Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required Use a column list in the SELECT clause to ensure that you only read a column if it is really required.
26. Which steps do you have to perform when defining a view using core data services (CDS)?
There are 3 correct answers to this question. Define the type mapping between ABAP and SAP HANA Use the DDL statement DEFINE VIEW and SQL like Syntax Create a proxy object for the defined view. Create a data definition in your ABAP package Specify the name of the SQL view in ABAP Dictionary.
27. What allows you to resolve errors quickly or warnings reported about the code? Quick Fix Debug perspective ABAP debugger Code execution.
28. When using ABAP Database Connectivity (ADBC) to issue native SQL calls to the database, which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? GET_METADATA SET_PARAM NEXT_PACKAGE SET_PARAM_TABLE.
29. The SAP HANA database is a hybrid in-memory database that combines Few technologies within.
What are these technologies? Column-based database technology Time-based database technology Object-based database technology Row-based database technology Value-based database technology.
30. You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? Use a Comma-separated column list Use the tilde symbol (~) to separate qualifier from column name Use the UP TO n ROWS addition Explicitly handle the client field Specify the database schema if it is not the user's default schema.
31. In which of the following situations could a row store table be more suitable than a column store table? The table contains mainly distinct values per column across rows. The table contains only a small number of records. The table contains text that you want to search. The table contains data that you want to aggregate.
32. Which data provisioning methods can you use when you need real time replications? SAP Data services SAP Replication server SAP Landscape transformation Replication server (SAP SLT) SAP HANA Direct extractor connection (SAP DXC).
33. You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. :it_books {it_books} @it_books it_books.
34. Which of the following is not involved in database table of “The New ABAP SQL Monitor – Architecture”? Runtime monitor data Selection data table Critical data table Performance data table.
35. Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Insert filter components Create data by members and tables Create Presentations.
36. What are the features of New Open SQL? Supports conditional expressions Supports arithmetic and string expressions Supports Code adjustment model Supports specific units of database.
37. What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)? List all ABAP Dictionary tables used in the procedure body in the USING clause. Use scalar types for all AMDP method parameters. Define all method parameters to be passed by value. Specify the database system and the language. Mark the AMDP method as a READ-ONLY database procedure.
38. How will you hide the attributes that are not required for client consumption? By setting the hidden property flag of the attribute column By setting the hidden property flag of the attribute in the Semantics screen By setting the hidden property flag of the attribute in the View By setting the hidden property flag of the attribute provider.
39. Which of the following take advantage of the computing power of multiple CPUs used by SAP HANA? Columnar data storage Database table compression Partitioning Parallel processing.
40. What are functions of the ABAP Managed Database Procedure (AMDP) framework? It deletes obsolete versions of the database procedure asynchronously It deletes obsolete versions of the database procedure synchronously It creates the database procedure when the AMDP is first activated It creates the database procedure when the AMDP is first called.
10. 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 AMDP.
In which cases does the call trigger the creation of the database procedure in SAP HANA? X is a stored procedure. X is an ABAP Dictionary table X is an SAP HANA view X is an AMDP method.
|
