NO.100 Analytic Privilege can be applied to (3 Answers)

NO.101 Your development team needs to include SAP HANA objects into an ABAP workbench request. You want to use SAP HANA Transport for ABAP (HTA) and NOT the SAP HANA Transport Container (HTC).
Why would you choose HTA?
Note: There are 2 correct answers to this question.

NO.102 You apply static code checks on your ABAP coding to find performance optimization potential and receive a message about a “Problematic SELECT * statement” issue. How can you improve the performance of your ABAP code?

NO.103 What are the different types of Variables in HANA? (3 right answers)

NO.104 Where can you consume associations in a Core Data Services (CDS) view? 3 ans

NO.105 Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.

NO.106 What is the operating system supported by HANA? (2 correct answers)

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

NO.108 Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 ans

NO.109 What output does the SAP HANA provide as a unique combination of hardware and software innovations? Please choose the correct answer.

NO.110 DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? There are 2 correct answers to this question.

NO.111 You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA.
Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.

NO.112 What are the elements of ABAP Database Integration? There are 3 correct answers to this question.

NO.113 Which conditional expressions can be used in Core Data Services (CDS) views? 2 ans

NO.114 You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? (Choose Two)

NO.115 One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.

NO.116 Which form of services is responsible for defining and consuming semantically rich data models. Please choose the correct answer.

NO.117 Which of the following is a limitation when you create an external view? Please choose the correct answer.