QUESTION 100
Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question

QUESTION 101
Where can you consume associations in a Core Data Services (CDS) view? 3 ans

QUESTION 102
List down the elements involved in User Management and Security in SAP Hana? There are 3 correct answers to this question

QUESTION 103
What are the advantages of column based tables? (3 correct answers)

QUESTION 104
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? Please choose the correct answer.

QUESTION 105
You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method.
Which additional steps are necessary to retrieve the result set into an internal table? 2 ans

QUESTION 106
Which is better from performance point of view?

QUESTION 107
In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag sa order gross amounts below a certain value. What information has to be provided in the GROUP BY list?

QUESTION 108
What can you include in the projection list of a Core Data Services (CDS) view? 3 ans

QUESTION 109
You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call? Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.

QUESTION 110
Which of the following categories of parameters can you use in the definition of an ABAP manage database procedure (AMDP)?
There are 3 correct answers to this question.

QUESTION 111
Which code-to-data capability is responsible for the Optimizations & Translation of “Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?. Please choose the correct answer.

QUESTION 112
Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Choose the correct answer

QUESTION 113
What are the different types of Calculation View? (2 answers)

QUESTION 114
For which purpose can you use literal values in an Open SQL statement?

QUESTION 115
What is the main purpose of Analytic Privilege?

QUESTION 116
What allows you to resolve errors quickly or warnings reported about the code? Please choose the correct answer.

QUESTION 117
Why is a security concept in SAP HANA required? There are 2 correct answers to this question

QUESTION 118
Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?

QUESTION 119
Which character is used to escape host variables in the new Open SQL syntax?

QUESTION 120
You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question.

QUESTION 121
You plan a database migration to SAP HANA and want to check your ABAP coding for performance optimization potential.
Which Code Inspector check variant can you use?

QUESTION 122
Which system schema/user is the owner of all the activated objects?

QUESTION 123
You create a check variant in the Code Inspector which includes the check ‘Search problematic Select * statements’. SAP HANA is used as the db In the check parameters, which value would you use for the percentage of fields that are effectively used?
Please choose the correct answer.

QUESTION 124
You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.