SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 141:

  AM DP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question.

  A. UNION specific syntax errors
  B. Database platform syntax errors
  C. Database independent syntax errors
  D. HANA specific syntax errors
  E. SQLScript errors
  C. Database independent syntax errors
  D. HANA specific syntax errors
  E. SQLScript errors

• Question 142:

  What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question

  A. Attribute view
  B. Schema view
  C. Column view
  D. Analytical view
  A. Attribute view
  D. Analytical view

• Question 143:

  Why is a security concept in SAP HANA required? There are 2 correct answers to this question

  A. Need to have selected users in SAP HANA for Information Management
  B. Access to ERP tables must be restricted
  C. Editing of SAP HANA data models should only be possible for "Users" of the model
  D. Database administration should be restricted to skilled
  B. Access to ERP tables must be restricted
  D. Database administration should be restricted to skilled

• Question 144:

  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
  A. ABAP dictionary tables used in procedure body
  C. CE function used in procedure Body
  D. AMDP Used in Procedure Body

• Question 145:

  In order to get language-specific data, which join is used in SAP HANA?

  A. Referential Join
  B. Language join
  C. Text Join
  D. It is not possible to fetch language-specific data in HANA
  C. Text Join

• Question 146:

  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.
  C. Perform calculations on data transferred to the database layer, then transfer the results back to the application layer.

• Question 147:

  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
  C. R3TR DDLS

• Question 148:

  Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 answers

  A. SQLM
  B. SE09
  C. SWLT
  D. ST22
  E. SE3S
  A. SQLM
  C. SWLT

  ---

  Explanation/Reference:

• Question 149:

  While creating a Graphical Calculation view, what are the options available in Tools palette? (4 answers)

  A. Union
  B. Cast
  C. Aggregation
  D. Projection
  E. Join
  F. Distinct
  A. Union
  C. Aggregation
  D. Projection
  E. Join

  ---

  Explanation/Reference:

• Question 150:

  Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.

  A. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement
  B. Use array variants of INSERT UPDATE MODIFY and DELETE
  C. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES
  D. Perform all calculations and aggregations in the ABAP layer
  B. Use array variants of INSERT UPDATE MODIFY and DELETE
  C. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES