SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 71:

  You plan a database migration to SAP HANA and want to check your ABAP coding for performance optimization potential.

  Which Code Inspector check variant can you use?

  A. PERFORMANCE_OPT
  B. CHECK_PERFORMANCE
  C. FUNCTIONAL_DB
  D. PERFORMANCE_DB
  D. PERFORMANCE_DB

  ---

  Explanation/Reference:

• Question 72:

  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
  A. In the Problems view

  ---

  Explanation/Reference:

• Question 73:

  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
  A. LEFT OUTER JOIN
  D. RIGHT OUTER JOIN

  ---

  Explanation/Reference:

• Question 74:

  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
  C. Check Pre-Requisites
  D. Identify Elementary Search Help
  E. Switch on proposal search for input fields

• Question 75:

  What are the types of schemas in HANA? (3 answers)

  A. System Defined Schema
  B. User Defined Schema
  C. SLT Derived Schema
  D. Dynamic Schema
  A. System Defined Schema
  B. User Defined Schema
  C. SLT Derived Schema

  ---

  Explanation/Reference:

• Question 76:

  Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question

  A. Data Evaluation Language(DEL)
  B. The Data Definition Language (DDL)
  C. Data Transferring Language(DTL)
  D. The Data Control Language (DCL)
  E. Data Manipulation Language (DML)
  B. The Data Definition Language (DDL)
  D. The Data Control Language (DCL)
  E. Data Manipulation Language (DML)

• Question 77:

  You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias? There are 3 correct answers to this question.

  A. CASTE Expression
  B. CASE expression
  C. Currency Conversion
  D. Nested CASE expression
  E. Unit conversion
  B. CASE expression
  C. Currency Conversion
  E. Unit conversion

  ---

  Explanation/Reference:

• Question 78:

  Which of the following is latest release of SAP HANA?

  A. SAP HANA 1.0 SP06
  B. SAP HANA 1.0
  C. SAP HANA 1.6 SP03
  D. SAP HANA 2.0 SPS 04
  D. SAP HANA 2.0 SPS 04

• Question 79:

  You are working with ABAP Development Tools (ADT) For Eclipse. Which of the following options belongs to the settings of a specific ABAP project rather than the entire Eclipse workbench?

  A. Code completion options
  B. Code formatting options
  C. Statement template options
  D. Editor shortcut key options
  B. Code formatting options

• Question 80:

  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
  A. CASE statements in the projection list
  D. COALESCE functions in the projection list

  ---

  Explanation/Reference: