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

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

A. Documented checks

B. Enhanced distribution of results

C. Configuration of check variants

D. Flexible schedule of check runs

Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Choose the correct answer

A. Create data by members and tables

B. Insert filter components

C. Swap axes

D. Create Presentations

Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA?

Note: There are 2 correct answers to this question.

A. Keep unnecessary load away from the database.

B. Minimize the number of database accesses

C. Minimize the amount of transferred data

D. Minimize the search overhead.

Which code-to-data capability is responsible for the Optimizations and Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?. Please choose the correct answer.

A. Database Optimization

B. Transparent Optimizations

C. HANA Specific features

D. Buffer system Optimization

You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question.

A. ABAP dictionary tables used in procedure body

B. ABAP dictionary views used in procedure body

C. CE function used in procedure Body

D. AMDP Used in Procedure Body

E. SAP HANA views used in procedure body

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

A. _SYS_XS

B. _SYS_BI

C. _SYS_REP0

D. _SYS_BIC

While creating a Graphical Calculation view, what are the options available in Tools palette? (4 answers)

A. Union

B. Cast

C. Aggregation

D. Projection

E. Join

F. Distinct

What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question.

A. Calculate aggregations using ABAP code on the application server to limit database load

B. Eliminate nested SELECT statements to reduce the overall number of database accesses

C. Use a column list in the SELECT clause to ensure that you only read a column if it is really required

D. Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required

You implement an ABAP-managed database procedure (AMDP). You want to query data from Calculation

view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb.

How can you address the calculation view?

Note; There are 2 correct answers to this questions.

A. "ha400.primdb/CA_BOOKINGS_COUNT"

B. _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT"

C. "ha400.primdb::CA_BOOKINGS_COUNT"

D. _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT"