SAP SAP Certifications E_HANAAW_18 Questions & Answers

• Question 101:

  What output does the SAP HANA provide as a unique combination of hardware and software innovations? Please choose the correct answer.

  A. Huge potential to optimize business applications that are running on SAP HANA

  B. The ability to create new complex processes with ABAP application cloud

  C. Huge potential to optimize AMDP application DATA Tables

  D. Huge potential to maximize the number of disk blocks in the application

  Correct Answer: A

• Question 102:

  Which system schema/user is the owner of all the activated objects?

  A. _SYS_XS

  B. _SYS_BI

  C. _SYS_REP0

  D. _SYS_BIC

  Correct Answer: C

• Question 103:

  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 alias

  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

  Correct Answer: A

• Question 104:

  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

  Correct Answer: AB

• Question 105:

  Discuss the basic approach of classical ABAP programming. 2 answers

  A. Collect all the data and perform parallel processing in ABAP

  B. Creating and consuming all the contents from network

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

  D. Keep load from the database

  Correct Answer: CD

• Question 106:

  Which of the following is not an element of Analytical view? Please choose the correct answer.

  A. Currency conversion is not applicable

  B. Join fact tables

  C. Read Data from the joined database tables D. Used to Joined table

  Correct Answer: A

• Question 107:

  You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question.

  A. ABAP dictionary tables used in procedure body

  B. ABAP dictionary views used in procedure body

  C. CE function used in procedure Body

  D. AMDP Used in Procedure Body

  E. SAP HANA views used in procedure body

  Correct Answer: ACD

• Question 108:

  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

  Correct Answer: A

• Question 109:

  What all are the steps to perform -To enable type-ahead for an input field on a screen? There are 3 correct answers to this question.

  A. Process on all the input fields

  B. Automatic updates of all the input fields

  C. Check Pre-Requisites

  D. Identify Elementary Search Help

  E. Switch on proposal search for input fields

  Correct Answer: CDE

• Question 110:

  You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.

  A. CAST( 'USO' AS abap.cuky) AS currency_key

  B. SUM( revenue ) AS total_revenue

  C. Crtdby AS created_by

  D. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS Order_type

  E. ASSOCIATION TO sflight AS_flights

  Correct Answer: ABD