Free Certified Development Specialist – ABAP for SAP HANA 2.0 Exam E_HANAAW_17 Exam Practice Test

Which is not a Golden Rule for Open SQL? Please choose the correct answer.

• Minimize the Number of Database Accesses
• Reduce the Database Load
• Minimize the Amount of Data Transferred
• Keep the result set large

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

• Core Data Services
• ITe services
• Conditional services
• Modell-ll services

An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question

• View restrictions
• Analytic restrictions
• Validity restrictions
• Activity restrictions
• Cube restrictions

What is Core Data Services (CDS)?

• A collection of services that provide information about the data volumes of the SAP HANA core tables
• A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system
• A collection of core features and services that provide data from the ABAP application server layer to the user interface
• A collection of domain-specific languages and services for definition and consumption of semantically rich data models

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

• Only Windows 8
• Red Hat Enterprise Linux (RHEL)
• SUSE Linux Enterprise Server
• Both Linux and Window 8

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

• All arithmetic expressions can be used for all type of variables
• All ABAP variables must be escaped with a proceeding @ sign.
• All Keywords are case sensitive.
• All fields in the GROUP BY clause must be separated by commas.

What is the language SAP HANA is developed in?

• Assembly
• O
• C++
• Java

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

• CASE statements in the projection list
• IF statements in the projection list
• WHILE statements in the WHERE clause
• COALESCE functions in the projection list
• CASE statements in the HAVING clause

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.

• Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement
• Use array variants of INSERT UPDATE MODIFY and DELETE
• Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES
• Perform all calculations and aggregations in the ABAP layer

Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question

• Calculation views
• ABAP managed database procedures
• Stored procedure
• Core data services views