E_HANAAW_18 by SAP Valid Free Exam Practice Test

Question 1

Which task does the ABAP Managed Database Procedure (AMDP) framework perform?

A. Deploy the database procedure whenever the AMDP is activated. B. Deploy the database procedure when the AMDP is first activated. C. Deploy a new version of the database procedure when the AMDP is first called. D. Deploy the database procedure whenever the AMDP is called.

Correct Answer: C

Question 2

Why would you implement Smart Data Access (SDA)?

A. To replicate data between SAP ECC and SAP HANA B. To generate delta images when sources cannot provide this function C. To define caching rules based on usage patterns D. To provide real-time access to remote data sources

Correct Answer: A

Question 3

Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? Note: There are 2 correct answers to this question.

A. Ensure the access to buffered tables uses the SAP table U buffer. B. Ensure the WHERE clause contains at least one index field. C. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement. D. Perform all calculations and aggregations in the ABAP U layer.

Correct Answer: B,C

Question 4

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

A. Optimized data partitioning B. Optimized access to column store tables C. Optimized access to column store tables D. Increased parallel processing

Correct Answer: A,D

Question 5

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 supports where-used list. B. It supports exception handling. C. It has syntax check at compile time. D. It supports locking and commit handling.

Correct Answer: A,B

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 - E_HANAAW_18 Exam Practice Test