SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 61:

  Which components can be a part of a calculation view? (2 answers)

  A. BAPIs
  B. Analytic View
  C. Tables
  D. Attribute View
  C. Tables
  D. Attribute View

• Question 62:

  Which of the statements are true for SQLScript? (2 answers)

  A. SQLScript is an open standard.
  B. SQLScript is used to push down data intensive logic into the database.
  C. SQLScript is a collection of extensions to SQL.
  B. SQLScript is used to push down data intensive logic into the database.
  C. SQLScript is a collection of extensions to SQL.

• Question 63:

  You analyse SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is NOT listed in SQLMD.

  What could be the reason?

  Note: There are 3 correct answers to this question.

  A. SQL Monitor was activated for a specific application server
  B. SQL monitor was activated with a filter that excludes database table Y
  C. The data has NOT yet been transferred to the SQL monitor database tables
  D. Program X was executed in the background.
  E. Database table Y is a buffered table.
  A. SQL Monitor was activated for a specific application server
  B. SQL monitor was activated with a filter that excludes database table Y
  C. The data has NOT yet been transferred to the SQL monitor database tables

  ---

  Explanation/Reference:

• Question 64:

  What are the features of New Open SQL? There are 2 correct answers to this question.

  A. Supports arithmetic and string expressions
  B. Supports Code adjustment model
  C. Supports specific units of database
  D. Supports conditional expressions
  A. Supports arithmetic and string expressions
  D. Supports conditional expressions

• Question 65:

  Where can you consume associations in a Core Data Services (CDS) view? 3 answers

  A. In the projection list
  B. In the name list
  C. In the input parameter list
  D. In the FROM clause
  E. In the WHERE and HAVING clauses
  A. In the projection list
  D. In the FROM clause
  E. In the WHERE and HAVING clauses

  ---

  Explanation/Reference:

• Question 66:

  An Analytic Privilege consists of several restrictions. What are they? There 3 correct answers to this question

  A. View restrictions
  B. Analytic restrictions
  C. Validity restrictions
  D. Activity restrictions
  E. Cube restrictions
  C. Validity restrictions
  D. Activity restrictions
  E. Cube restrictions

• Question 67:

  In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer

  A. Code completion option
  B. Statement Template options
  C. Editor shortcut options
  D. Code formatting option
  D. Code formatting option

• Question 68:

  List down the elements involved in User Management and Security in SAP Hana? There are 3 correct answers to this question

  A. Manage users
  B. Assign Job security
  C. Assign security
  D. Work Management
  E. Create users
  A. Manage users
  C. Assign security
  E. Create users

• Question 69:

  What language one should know to work in SAP HAN A?

  A. Java
  B. ABAP
  C. C#
  D. SQL
  D. SQL

• Question 70:

  When would you use a column store table instead of a row store table? There are 2 correct answers to this question.

  A. When you require aggregation and analysis of values
  B. When the table has a small number of records
  C. When there are mainly distinct values in the table
  D. When you want to enable a full-text-search of the table
  A. When you require aggregation and analysis of values
  D. When you want to enable a full-text-search of the table