E_HANAAW_17 Online Practice Questions and Answers

Where can you consume associations in a Core Data Services (CDS) view? 3 answers

A. In the projection list

B. In the name list

C. In the input parameter list

D. In the FROM clause

E. In the WHERE and HAVING clauses

How can you exchange SQL Monitor data between two systems?

A. Create a snapshot of the SQL Monitor data, export it to the file system, and then import it to the target system.

B. Deactivate the SQL Monitor in the source system and activate the SQL Monitor in the target system.

C. Configure a secondary database connection to the target system and query the data in the SQL Monitor.

D. Create and release a transport request containing the SQL Monitor log files.

You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.

A. View CA_CUSTOMER has deployment mode A.

B. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK

C. SYSTEM P81 has SAP HANA has primary database

D. PACKAGE ZHA400J30 HAS deployment Mode A

In ABAP Development Tools for SAP NetWeaver, you execute the ABAP Test Cockpit on an ABAP program to find performance optimization potential.

Where can you find the result of the static code checks?

A. In the Problems view

B. In the Project Explorer view

C. In the Performance Analysis view

D. In the Outline view of the ABAP Performance perspective

Which system schema/user is the owner of all the activated objects?

A. _SYS_XS

B. _SYS_BI

C. _SYS_REP0

D. _SYS_BIC

What are the features associated with ABAP CDS? There are 3 correct answers to this question.

A. Create

B. Export

C. Update

D. Read

E. Distribution

Why is not a key factor of ALV for HAN A? Please choose the correct answer.

A. The data display is restricted to a maximum of 2 billion cell

B. To supply suitable values for any input parameters

C. To activate and execute the program in the application

D. Derived column headings from the data element

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM )?

A. Existence check for secondary indexes

B. Use of Native SQL and DB Hints

C. Missing ORDER BY or SORT after SELECT

D. Direct access to table pools/cluster

What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.

A. Open system properties

B. Administration console

C. Development properties

D. System Properties

Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 answers

A. SQLM

B. SE09

C. SWLT

D. ST22

E. SE3S