E_HANAAW_18 Online Practice Questions and Answers

You want to define an ABAP Core Data Services (CDS) view that totals the NET_AMOUNT column for each sales order (column SOJD). Which SELECT statement would you use in the definition? Please choose the correct answer.

A. select from snwd_so {so_id( sum(net_amount) as sum_amount} order by sojd

B. select from snwd_so {so_id( sum(net_amount) as sum_amount} group by sojd

C. select from snwd_so {sojd, sum(net_amount) as sum_amount}

D. select from snwd_so {so_id( sum(net_amount) as sum_amount} group by net_amount

HANA modeling views can be created under:

A. Catalog

B. Schema

C. File System

D. Content

Explain the Enterprise Information System of- SAP HANA Implementation Scenarios? There are 3 correct answers to this question

A. HANAAccelerators

B. All HANA Combinations on one platform

C. HANA Modeling

D. All SAP applications on one SAP HANA platform

E. Business Suite on HANA/ BW on SAP HANA

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

What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question

A. Delimited identifiers

B. Limited identifiers

C. Undelimited Identifiers

D. Numeric identifiers

What should you do to follow the code-to-data approach to programming? 2 answers A. Perform expensive calculations on the database

B. Transfer all data from the database to the ABAP layer, and then aggregate the results.

C. Perform expensive calculations on the ABAP application server.

D. Aggregate data on the database, and transfer the results to the ABAP layer.

You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? (Choose Two)

A. It has syntax check as compile time.

B. It supports exception handling

C. It supports locking and commit handling

D. It supports where-used list.

Which TADIR object type is used for the definition of a Core Data Services (CDS) view?

A. R3TR TABL

B. R3TR VIEW

C. R3TR DDLS

D. R3TR DDIC

You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA. Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.

A. Read-write

B. Read only

C. Write only

D. Read-update

Which components can be a part of a calculation view? (2 answers)

A. BAPIs

B. Analytic View

C. Tables

D. Attribute View