E_HANAAW_17 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

In addition to closing the result set. What does the CLOSE method of the CL_SQL_RESULT_SET class when using ABAP Database Connectivity (ADBC) do? Please choose the correct answer.

A. Release resources

B. Update resources

C. Update resources

D. Update packages

Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

A. Service Adaptation Description Language (SADL)

B. Process Agent Framework (PAF)

C. ABAP Messaging Channels (AMC)

D. ABAP Managed Database Procedures (AMDP)

User STUDENT_A creates and activates a design-time Object. In which schema is the runtime object generated?

A. SYS_BI

B. SYSTEM

C. _SYS_BIC

D. STUDENT_A

Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench?

There are 3 correct answers to this question.

A. Full-text index

B. Database procedure proxy

C. ABAP program containing new Open SQL

D. Core Data service (CDS) view

E. External view

According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?

A. Perform regular performance scans on your ABAP custom coding as part of the development process.

B. Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process.

C. Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5.

D. Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer.

A. ROW

B. GLOBAL TEMPORARY

C. COLUMN

D. LOCAL TEMPORARY

What is the main advantage of SQLScript? (2 answers)

A. SQLScript can be better modularized than traditional SQL

B. SQLScript code can easily be translated into modeling view

C. SQLScript is faster than traditional SQL

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

What is the main benefit of the SQL Performance Tuning Worklist?

A. It establishes a governance process for performance optimizations.

B. It automatically translates ABAP coding to SQLScript.

C. It allows you to correlate the results of an ABAP source code analysis with SQL runtime data.

D. It allows you to simulate the impact of performance optimization patterns.

An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question

A. View restrictions

B. Analytic restrictions

C. Validity restrictions

D. Activity restrictions

E. Cube restrictions

What are the two types of editors available in ADT? There are 2 correct answers to this question.

A. Eclipse (native)

B. Client (native)

C. SAP (GUI)

D. ABAP (native)

What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

A. Use native SQL to access SAP HANA built-in functions.

B. Perform expensive calculations on the database.

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

D. Perform expensive calculations on the ABAP application server.

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

Which recent software innovations are applied in SAP HANA? 3 answers

A. Columnar data storage

B. Automated de-installation at system shutdown

C. Improved data compression algorithms

D. Insert Only approach

E. Random Undefined Multi-Memory Swapping (RUMMS)

Why is a security concept in SAP HANA required? There are 2 correct answers to this question

A. Need to have selected users in SAP HANA for Information Management

B. Access to ERP tables must be restricted

C. Editing of SAP HANA data models should only be possible for "Users" of the model

D. Database administration should be restricted to skilled