Practice Test for ABAP on HANA Certification Exam Code E_HANAAW_17
Training.sap.com link
Click Here for Quiz Total 40 Question
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
www.simplilearnings.com
0 Comments