SAP E_HANAAW_18 Exam Practice Test Instant Access

Question 1

You are debugging in ABAP Development Tools in Eclipse.

What features are available? Note: There are 2 correct answers to

this question.

ADebugger scripting

BWatch points

CConditional breakpoints

DMemory usage analysis

Answer : B, C

Question 2

When using an SAP HANA full text search, what do you have to keep in mind?

AThe LIKE operator is required in your SELECT statement to implement fuzzy logic.

BSAP HANA has to be the primary database to create a full text search.

CThe SCORE( ) function is required to ensure the best hits of your search appear on top.

DThe full-text index is always updated asynchronously.

Answer : C

Question 3

Which of the following features were added to the ABAP dictionary to support the SAP HANA database? Note: There are 3 correct answers to this question.

ADe-pooling and de-clustering

BStorage type for tables

CDefinition of enhancement category

DChange of data class

EDefinition of full-text indexes

Answer : A, B, E

Question 4

Which task can you perform with the SQL Monitor (transaction SQLM)?

ACapture the SQL profile of an application.

BSearch for problematic SELECT * statements.

CCombine static and dynamic performance analysis results.

DDisplay the execution plan of an SQL statement.

Answer : A

Question 5

You created and activated a database procedure. From where can you call this procedure? Note: There are 2 correct answers to this question.

AFrom a Script-based calculation view

BFrom a Core Data Services view

CFrom a graphical calculation view

DFrom another database procedure

Answer : A, D

Question 6

You import an ABAP workbench request into an SAP system P81. The ABAP workbench request contains a single SAP HANA view CA_CUSTOMER that belongs to SAP HANA content package ZHA400_00. Which prerequisites are mandatory for an implicit deployment of the SAP HANA view onto the database? Note: There are 2 correct answers to this question.

AView CA_CUSTOMER has deployment mode A.

BPackage ZHA400_00 has deployment mode A.

CSystem P81 has SAP HANA as primary database.

DPackage ZHA400_00 is listed in table SNHI DUP PREWORK.

Answer : C, D

Question 7

Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? Note: There are 3 correct answers to this question.

AABAP Test Cockpit (transaction: ATC)

BSQL Trace (transaction: ST05)

CDatabase Performance Monitor (transaction: DB50)

DSQL Monitor (transaction: SQLM)

ECode Inspector (transaction: SCI)

Answer : A, D, E

SAP E_HANAAW_18 SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Exam Practice Test