E_HANAAW_17 Online Practice Questions and Answers

What is the full form of HANA?

A. High-Performance Analytic Accelerator

B. High-Performance Analytic Application

C. High Accelerator Numeric Analytics

D. High-Performance Analytic Appliance

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

The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.

A. Avoid idiling CPU cores

B. Avoid CPU cache misses

C. Avoid optimizing data

D. Avoid single network

What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 answers)

A. Changes to Delta Container

B. You need to refresh the content of the container manually

C. Automatic release of units

D. Take snapshot manually before releasing of the container

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

What you must do when you define and implement an ABAP Managed Database Procedure AMDP? There are 3 correct answers to this question.

A. Define all the method parameters to pass by value

B. List all the ABAP dictionary tables used in the procedure body in the USING clause

C. Use Scalar types for all the AMDP method parameters

D. Specify the database system and language

E. Mark the AMDP method as read-only

Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question

A. Convert crosstab cells to formula

B. Analyze data with the design pane

C. Suggests style sets for crosstabs

D. Sort data by characteristics

Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question

A. Analytic privileges

B. Package privileges

C. Application privileges

D. Object privileges

E. System privileges

You apply static code checks on your ABAP coding to find performance optimization potential and receive a message about a "Problematic SELECT * statement" issue. How can you improve the performance of your ABAP code?

A. Use Native SQL to perform the SELECT * statement.

B. Use the ABAP pragma ##OPTIMIZE_QUERY.

C. Use the Open SQL SELECT RELEVANT statement.

D. Use a field list containing only the relevant fields.

Which conditional expressions can be used in Core Data Services (CDS) views? 2 answers A. CASE statements in the projection list

B. IF statements in the projection list

C. WHILE statements in the WHERE clause

D. COALESCE functions in the projection list

E. CASE statements in the HAVING clause