SAP E_HANAAW_18 Exam Practice Test Instant Access

Question 1

Which of the following tools and programming techniques use the SQL Data Definition Language? Note: There are 2 correct answers to this question.

ACore Data Services (CDS) access control

BCore Data Services (CDS) data definition

COpen SQL

DABAP Dictionary

Answer : B, C

Question 2

You analyze SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its dat

a. But the relevant database access is NOT listed in SQLMD. What could be the reason? Note: There are 3 correct answers to this question.

ASQL Monitor was activated with a filter that excludes database table Y.

BSQL Monitor was activated for a specific application server.

CDatabase table Y is a buffered table.

DThe data has NOT yet been transferred to the SQL Monitor database tables.

EProgram X was executed in the background.

Answer : A, B, D

Question 3

Which of the following features does the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offer? Note: There are 2 correct answers to this question.

AFlexible schedule of check runs

BEnhanced distribution of results

CDocumented checks

DConfiguration of check variants

Answer : A, B

Question 4

Which rules does SAP recommend to improve the performance of ABAP reports on SAP HANA? Note: There are 2 correct answers to this question.

AEnsure the access to buffered tables uses the SAP table U buffer.

BPerform all calculations and aggregations in the ABAP U layer.

CEnsure the WHERE clause contains at least one index field.

DUse SELECT FOR ALL ENTRIES instead of a nested SELECT statement.

Answer : C, D

Question 5

You are using ABAP Development Tools, and you have placed your cursor on a method name in a class. What key do you use to navigate between a method definition and its implementation?

AF2

BF3

CF4

DF1

Answer : B

Question 6

You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node:

AImage 1

BImage 2

CImage 3

DN/A

Answer : C

Question 7

You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause? Note: There are 3 correct answers to this question.

ASAP HANA views used in the procedure body

Bfunctions used in the procedure body

CAMDPs used in the procedure body

DABAP Dictionary tables used in the procedure body

EABAP Dictionary views used in the procedure body

Answer : C, D, E

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