SAP E_HANAAW_18 Quiz 1 Topic 3 Questions 1-5

Question: 1

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)

Show Answer

Question: 2

In a graphical calculation view, you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? Note: There are 2 correct answers to this question.

ACreate an input parameter for the ADDRESS field.

BExclude the ADDRESS field from the union.

CCreate a restricted column for the ADDRESS field.

DMap the ADDRESS field to a constant value.

Show Answer

Question: 3

Which task does the ABAP Managed Database Procedure (AMDP) framework perform?

ADeploy a new version of the database procedure when the AMDP is first called.

BDeploy the database procedure whenever the AMDP is called.

CDeploy the database procedure when the AMDP is first activated.

DDeploy the database procedure whenever the AMDP is activated.

Show Answer

Question: 4

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.

Show Answer

Question: 5

You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.

ACASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type

BCAST( 'USD' AS abap.cuky ) AS currency_key

Ccrtdby AS created_by

DSUM( revenue ) AS total_revenue

EASSOCIATION TO sflight AS .flights

Show Answer

SAP E_HANAAW_18 Quiz:1 Topic:3 Questions:1-5