SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 131:

  Which of the following is a limitation when you create an external view? Please choose the correct answer.

  A. You must include the name of the SAP HANA view in the name of the external view.
  B. You can only use native SQL to consume the external view
  C. You must know the underlying tables and join conditions of the SAP HANA view.
  D. You must use the ABAP Development tools (ADT) TO CREATE the external view
  D. You must use the ABAP Development tools (ADT) TO CREATE the external view

• Question 132:

  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
  A. Huge potential to optimize business applications that are running on SAP HANA

• Question 133:

  Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 answers

  A. FOR db (db = HDB...)
  B. LANGUAGE dbjang (dbjang = SQLSCRIPT...)
  C. BY DATABASE PROCEDURE
  D. CLIENT SPECIFIED
  E. AUTHORIZATION db_auth (db_auth = SYSTEM ...)
  A. FOR db (db = HDB...)
  B. LANGUAGE dbjang (dbjang = SQLSCRIPT...)
  C. BY DATABASE PROCEDURE

  ---

  Explanation/Reference:

• Question 134:

  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
  B. Restrict row level access so that user will be able to see only certain portion of the data

• Question 135:

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

  ---

  Explanation/Reference:

• Question 136:

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

• Question 137:

  You developed an ABAP program using ABAP Development Tools for SAP NetWeaver. How can you execute it? 2 answers

  A. In the Project Explorer view, right-click the program and choose Run As -- ABAP Application from the context menu.
  B. Use the Open Development Object dialog (CTRL+SHIFT+A) and enter /Execute in the search field.
  C. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.
  D. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut Fl.
  E. Call transaction SRUN_ADT and enter the name of the ABAP program.
  A. In the Project Explorer view, right-click the program and choose Run As -- ABAP Application from the context menu.
  C. Open the ABAP program in the ABAP Development perspective and execute it using the shortcut F8.

  ---

  Explanation/Reference:

• Question 138:

  HANA modeling views can be created under:

  A. Catalog
  B. Schema
  C. File System
  D. Content
  D. Content

  ---

  Explanation/Reference:

• Question 139:

  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
  A. Currency conversion is not applicable

• Question 140:

  One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration.

  What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.

  A. Direct access to a cluster on the database
  B. Left outer joins in open SQL statements
  C. Native SQL statements
  D. Code that relies on implicit database sorting
  E. ORDER BY Clauses in Open SQL statements
  A. Direct access to a cluster on the database
  C. Native SQL statements
  D. Code that relies on implicit database sorting

  ---

  Explanation/Reference: