SAP ABAP on HANA sample practice Questions

Sample ABAP on HANA certification Questions

Question No 1:

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. 

A. Include the client field in the WHERE condition.

B. Use the CLIENT SPECIFIED addition.

C. Include the client field in the join condition.

D. Include the client field in the field list.

Answer : A & C

___________________________________________________________________________________________

Question No 2:

Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this

A. Avoid transferring large result sets between database and client applications.

B. Move data-intensive calculations from the database to an application  server.

C. Filter data in lower layers.

D. Define indexes on the columns that are used in calculations

Answer : A & C

___________________________________________________________________________________________

Question No 3: 

In SAP HANA, tables are stored in row store by default. Is this sentence True or False.

Answer: False.

In HANA, tables are stored in column store by default.

___________________________________________________________________________________________

Question No 4:

It is not possible to create secondary index in SAP HANA database, Is this true or false.

Answer: False.

___________________________________________________________________________________________

Question No 5:

What should you do to follow the code-to-data approach to programming? There are 2 correct answers to this question.

A. Aggregate data on the database, and transfer the results to the ABAP layer.

B. Transfer all data from the database to the ABAP layer, and then aggregate the results.

C. Perform expensive calculations on the ABAP application server.

D. Perform expensive calculations on the database.

Answer: A & D.

___________________________________________________________________________________________

Question No 6:

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?

A. GET_METADATA

B. NEXT_PACKAGE

C. SET_PARAM

D.SET_PARAM_TABLE

Answer: B

___________________________________________________________________________________________

Question No 7:

List down the four main concepts of the SAP HANA database? There are 3 correct answers to this question

A. Object store

B. Compression

C. Tools combinations

D. Partitioning

E. Column Store

Answer: B D E.

___________________________________________________________________________________________

Question No 8:

How to call the stored procedures in ABAP code? Please choose the correct answer. 

A. Native SQL

B. CDS view

C. Only SQL

D. Open SQL

Answer: A.

Stay tuned. Will continue..