Question. 1 

You have created a CDS view and used alias names for some of its elements. In which of the  following cases is the alias name mandatory? Note: There are 3 correct answers to this question. 

A. SUM( revenue ) AS total_revenue 

B. CAST( 'USD' AS abap.cuky ) AS currency_key 

C. crtdby AS created_by 

D. CASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type 

E. ASSOCIATION TO sflight AS _flights 

Answers A B D 

Question. 2 

You want to execute a native SQL statement in your program. Why should you use ABAP Database  Connectivity (ADBC)? Note: There are 2 correct answers to this question. 

A. It has syntax check at compile time. 

B. It supports exception handling. 

C. It supports locking and commit handling. 

D. It supports where-used list. 

Answers B D 

Question. 3 

You created and activated a database procedure. From where can you call this procedure? Note:  There are 2 correct answers to this question. 

A. From another database procedure 

B. From a Script-based calculation view 

C. From a Core Data Services view 

D. From a graphical calculation view 

Answers A B 

Question. 4 

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? 

A. LOCAL TEMPORARY 

B. ROW

C. HISTORY COLUMN 

D. GLOBAL TEMPORARY 

Answers A 

Question. 5 

Which tools can you use to provide input data for the SQL Performance Tuning Worklist  (transaction SWLT)? Note: There are 3 correct answers to this question. 

A. SQL Trace (transaction: ST05) 

B. SQL Monitor (transaction: SQLM) 

C. Database Performance Monitor (transaction: DB50) 

D. Code Inspector (transaction: SCI) 

E. ABAP Test Cockpit (transaction: ATC) 

Answers B D E 

Question. 6 

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?

A. Existence check for Secondary Indexes 

B. Missing ORDER BY or SORT after SELECT 

C. Direct access to Table Pools/Cluster 

D. Use of Native SQL and DB Hints 

Answers B 

Question. 7 

What benefits does SAP HANA Data Compression provide? Note: There are 2 correct answers to  this question. 

A. Increased parallel processing 

B. Optimized data partitioning 

C. Optimized access to column store tables 

D. Reduced memory consumption 

Answers A B 

Question. 8 

You import an ABAP workbench request into an SAP system P81. The ABAP workbench request  contains a single SAP HANA view CA_CUSTOMER that belongs to SAP HANA content package ZHA400_00. Which prerequisites are mandatory for an implicit deployment of the SAP HANA view  onto the database? Note: There are 2 correct answers to this question. 

A. View CA_CUSTOMER has deployment mode A. 

B. Package ZHA400_00 has deployment mode A. 

C. Package ZHA400_00 is listed in table SNHI_DUP_PREWORK. 

D. System P81 has SAP HANA as primary database. 

Answers C D 

Question. 9 

Which of the following features were added to the ABAP dictionary to support the SAP HANA  database? Note: There are 3 correct answers to this question. 

A. De-pooling and de-clustering 

B. Definition of full-text indexes 

C. Storage type for tables 

D. Definition of enhancement category 

E. Change of data class 

Answers A B C 

Question. 10 

Which of the following features does the ABAP Test Cockpit offer that the ABAP Code Inspector  does NOT offer? Note: There are 2 correct answers to this question. 

A. Flexible schedule of check runs 

B. Enhanced distribution of results 

C. Configuration of check variants 

D. Documented checks 

Answers A B