SAP E_HANAAW_17 Exam Dumps

Which of the following can be part of an analytic view? (3 answers)

A. Query transformation
B. Logical joins
C. Attributes
D. Data foundation
E. Unions

Answer: B,C,D

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

Answer: A

You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.

A. Replace UP TO n ROWS additions
B. Specify the schema for every table
C. Replace ORDER BY additions
D. Replace CORRESPONDING FIELDS additions
E. Add explicit client handling 

Answer: A,D,E

Which of the following is true? (2 correct answers)

A. A read only procedure cannot call read-write procedure.
B. A Read-write procedure cannot call another read-write procedure.
C. A read-write procedure can call both read-write and read only procedures.

Answer: A,C

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

A. All arithmetic expressions can be used for all type of variables
B. All ABAP variables must be escaped with a proceeding @ sign.
C. All Keywords are case sensitive.
D. All fields in the GROUP BY clause must be separated by commas.

Answer: B,D

In an Open SQL query, you select the sum of sales order gross amounts and a CASE statement to flag sa order gross amounts below a certain value. What information has to be provided in the GROUP BY list?

A. The CASE statement as provided in the SELECT list without its alia
B. The alias of the CASE construct used in the SELECT list
C. None; the GROUP BY list is added automatically
D. The name of the gross amount column that is used in the CASE statement

Answer: A

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. 

Answer: A

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

Answer: B,D

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 

Answer: A,C,D

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

Answer: B,D

Which is better from performance point of view?

A. SQLScript Procedure
B. Modeling Views

Answer: B

What is the main purpose of Analytic Privilege?

A. Restrict users to access database tables
B. Restrict row level access so that user will be able to see only certain portion of the data
C. Restrict user to access modeling view

Answer: B