SAP SAP Certifications E_HANAAW_18 Questions & Answers

• Question 71:

  What are functions of the ABAP Managed Database Procedure (AMDP) framework? (2 answers)

  A. It deletes obsolete versions of the database procedure synchronously

  B. It deletes obsolete versions of the database procedure asynchronously

  C. It creates the database procedure when the AMDP is first called.

  D. It creates the database procedure when the AMDP is first activated.

  Correct Answer: BC

• Question 72:

  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

  Correct Answer: B

• Question 73:

  You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional regressions. Which Code Inspector check variant can you use?

  A. PREV_FUNC_REG

  B. FUNCTIONAL_DB

  C. FUNCTIONAL_CHECK

  D. PERFORMANCE DB

  Correct Answer: B

• Question 74:

  What can you include in the projection list of a Core Data Services (CDS) view? 3 answers

  A. ABAP system fields such as sy-langu or sy-mandt \/ CI String constants and literal values

  B. Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause

  C. A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause

  D. A field from the projection list of another CDS view used in the FROM clause

  Correct Answer: BCD

• Question 75:

  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

  Correct Answer: BC

• Question 76:

  DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? There are 2 correct answers to this question.

  A. Column store

  B. Development Store

  C. Row store

  D. Technology store

  E. Re-use component store

  Correct Answer: AC

• Question 77:

  Discuss the basic approach of classical ABAP programming? There are 2 correct answers to this question.

  A. Get all the data you need on the application server and do your processing in ABAP

  B. Creating and consuming all the contents from network

  C. Keep load from the database

  D. Collect all the data and perform Parallel processing in ABAP

  Correct Answer: AC

• Question 78:

  Which of the below has huge negative impact on performance? (2 answers)

  A. Mixing up SQL statement and CE functions

  B. Join on calculated column

  C. Inner Join

  Correct Answer: AB

• Question 79:

  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

  Correct Answer: C

• Question 80:

  Which system schema contains the list of Activated and inactive Objects?

  A. _SYS_BIC

  B. _SYS_REPO

  C. _SYS_XS

  D. _SYS_BI

  Correct Answer: B