ABAP CERTIFICATION Multiple Choice
Questions (MCQs)
What information can you specify using annotations (marked with the @ sign) when you define a Core Data Services (CDS) view in an ABAP system? There are 3 correct answers to this question.
- The logic for aggregations, grouping records, and filtering groups of the CDS view.
- The join conditions of the CDS view.
- The name of the representation of the CDS view in the ABAP dictionary.
- The client dependency of the CDS view.
- The extent to which records of the CDS view should be buffered on the application server.
Correct Answer: 3, 4, 5
1. Explain The Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question.
- System privileges
- Object privileges
- Analytic privileges
- Delta privileges
- Application privileges
Correct Answer: 1, 2, 3
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. How do you refer to the parameter? Choose one correct answer.
- {it_books}
- :it_books
- @it_books
- it_books
Correct Answer: 2
What must you do when you define and implement an ABAP Managed Database Procedure (AMDP)? There are 3 correct answers to this question
- Use scalar types for all AMDP method parameters.
- Mark the AMDP method as a READ-ONLY database procedure.
- List all ABAP Dictionary tables used in the procedure body in the USING clause.
- Specify the database system and the language.
- Define all method parameters to be passed by value.
- BDC program is used for following except
Correct Answer: 3,4,5
Which of the following are performance recommendations when using SAP HANA? There are 2 correct answers to this question.
- Define indexes on the columns that are used in calculations.
- Move data-intensive calculations from the database to an application server.
- Avoid transferring large result sets between database and client applications.
- Filter data in lower layers.
Correct Answer: 3,4
