Practice E_HANAAW_17 Exam Online

Question 1

Which engine is used to execute Analytic View?

A : SQL Engine

B : Calc Engine

C : OLAP Engine

D : Join Engine

Answer: C

Question 2

Which system schema contains the list of Activated and inactive Objects?

A : Which system schema contains the list of Activated and inactive Objects?

B : Used to access local or remote database system

C : Use Schema for the Connections

D : Maintain only HANA specific objects

Answer: A,B

Question 3

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.

A : A value that you calculate based on the number of tables

B : A higher value than on a traditional, row-store only based database

C : A lower value than on a traditional, row-store only based database

D : The same value as on a traditional, row-store only based database

Answer: C

Question 4

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

A : Use native SQL to access SAP HANA built-in functions.

B : Perform expensive calculations on the database.

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

D : Perform expensive calculations on the ABAP application server.

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

Answer: A,B,C

Question 5

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

A : Read-write

B : Read only

C : Write only

D : Read-update

Answer: B

Name:	SAP Certified Development Specialist - ABAP for SAP HANA 2.0
Exam Code:	E_HANAAW_17
Certification:	SAP Certified Development Specialist
Vendor:	SAP
Total Questions:	175
Last Updated:	Apr 22, 2024

SAP E_HANAAW_17