SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 1:

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

  What is the operating system supported by HANA? (2 answers)

  A. Only Windows 8
  B. Red Hat Enterprise Linux (RHEL)
  C. SUSE Linux Enterprise Server
  D. Both Linux and Window 8
  B. Red Hat Enterprise Linux (RHEL)
  C. SUSE Linux Enterprise Server

• Question 3:

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

  You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

  A. :it_books
  B. it_books
  C. {it.books}
  D. @it_books
  A. :it_books

• Question 5:

  What are the benefits of using the SQL Monitor (transaction SQLM)? There are 2 correct answers to this question.

  A. It collects monitoring data asynchronously without additional database interaction.
  B. It schedules ABAP programs to monitor and log all database accesses.
  C. It displays the database execution plan for all SQL statements.
  D. It can be active in a production system with minimal performance overhead.
  A. It collects monitoring data asynchronously without additional database interaction.
  D. It can be active in a production system with minimal performance overhead.

• Question 6:

  Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?

  A. The filter condition for the association
  B. The cardinality of the association
  C. The alias for the association
  D. The target entity of the association
  D. The target entity of the association

• Question 7:

  What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question

  A. Active clusters for all servers
  B. Shared file systems for only one server
  C. Services-Name and index server on all nodes
  D. High availability configuration
  C. Services-Name and index server on all nodes
  D. High availability configuration

• Question 8:

  DB-Specific Properties that allows switching between storage types when running on an SAP HANA database. What are these storage types? There are 2 correct answers to this question.

  A. Column store
  B. Development Store
  C. Row store
  D. Technology store
  E. Re-use component store
  A. Column store
  C. Row store

• Question 9:

  What is the main advantage of SQLScript? (2 answers)

  A. SQLScript can be better modularized than traditional SQL
  B. SQLScript code can easily be translated into modeling view
  C. SQLScript is faster than traditional SQL
  A. SQLScript can be better modularized than traditional SQL
  C. SQLScript is faster than traditional SQL

• Question 10:

  What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question

  A. Account-based Profitability
  B. Costing-based Profitability
  C. Product-based Profitability
  D. Service-based profitability
  A. Account-based Profitability
  B. Costing-based Profitability