SAP SAP Certifications E_HANAAW_17 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 follow the Code-to-Data paradigm in your ABAP coding.

  Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecessary load away from the database"?

  A. Perform business logic and aggregations on database table content, then transfer the results to the application layer.

  B. Perform join operations on database tables, then transfer the results to the application layer.

  C. Perform calculations on data transferred to the database layer, then transfer the results back to the application layer.

  D. Perform text search operations on database table content, then transfer the results to the application layer.

  Correct Answer: C

• Question 73:

  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 74:

  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 75:

  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 76:

  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 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:

  ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question.

  A. Data Manipulation Language

  B. The Data Control Language

  C. The Database Language

  D. The Data Definition Language

  E. Data Transferred Language

  Correct Answer: ABD

• Question 79:

  Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 answers

  A. LEFT OUTER JOIN

  B. CROSS JOIN

  C. FULL OUTER JOIN

  D. RIGHT OUTER JOIN

  E. REFERENTIAL JOIN

  Correct Answer: AD

• 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