SAP E_HANAAW_18 Exam Practice Test Instant Access

Question 1

You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. See Picture...This is the data that goes into the aggregation node: What does the result of the aggregation look like? See Pictures

AImage 1

BImage 2

CImage 3

DN/A

Answer : C

Question 2

You are debugging in ABAP Development Tools in Eclipse. What features are available? Note: There are 2 correct answers to this question.

AMemory usage analysis

BWatchpoints

CConditional breakpoints

DDebugger scripting

Answer : B, C

Question 3

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

ACapture the SQL profile of an application.

BSearch for problematic SELECT * statements.

CDisplay the execution plan of an SQL statement.

DCombine static and dynamic performance analysis results.

Answer : A

Question 4

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.

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

BProgram X was executed in the background.

CDatabase table Y is a buffered table.

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

ESQL Monitor was activated for a specific application server.

Answer : A, B, E

Question 5

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.

CPackage ZHA400_00 is listed in table SNHI_DUP_PREWORK.

DSystem P81 has SAP HANA as primary database.

Answer : C, D

Question 6