SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 151:

  List down the three main concepts of the SAP HANA database There are 3 correct answers to this question

  A. Column Store
  B. Tools combinations
  C. Object store
  D. Partitioning
  E. Compression
  A. Column Store
  D. Partitioning
  E. Compression

• Question 152:

  Before migrating to SAP HANA, which Code Inspector check do you have to consider to avoid functional regressions?

  A. Standard Web Dynpro checks
  B. Search for DB operations across modularization units
  C. SELECT statements that bypass the table buffer
  D. Use of the ADBC interface
  D. Use of the ADBC interface

• Question 153:

  Which system schema contains the list of Activated and inactive Objects? 2 answers

  A. Used to access local or remote database system
  B. Maintain, Monitor and test secondary database connection
  C. Use Schema for the Connections
  D. Maintain only HANA specific objects
  A. Used to access local or remote database system
  B. Maintain, Monitor and test secondary database connection

  ---

  Explanation/Reference:

• Question 154:

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

  What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question

  A. Fewer data duplication and movement
  B. Exploit structured contents in SQL
  C. Easy to use modeling tool
  D. Large number of toolkits are available
  A. Fewer data duplication and movement
  C. Easy to use modeling tool

• Question 156:

  Which engine is used to execute Analytic View?

  A. SQL Engine
  B. Calc Engine
  C. OLAP Engine
  D. Join Engine
  C. OLAP Engine

• Question 157:

  You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the db.

  In the check parameters, which value would you use for the percentage of fields that are effectively used?

  Please choose the correct answer.

  A. A value that you calculate based on the number of tables
  B. A higher value than on a traditional, row-store only based database
  C. A lower value than on a traditional, row-store only based database
  D. The same value as on a traditional, row-store only based database
  C. A lower value than on a traditional, row-store only based database

  ---

  Explanation/Reference:

• Question 158:

  When are referential joins executed in analytical views? Choose the correct answer

  A. When all the tables are optimized
  B. When fields are selected
  C. When fields are optimized
  D. When fields from both the tables are requested
  D. When fields from both the tables are requested

• Question 159:

  Which of the following option is not the main capability of SAP BusinessObjects Analysis for OLAP? Choose the correct answer

  A. Create data by members and tables
  B. Insert filter components
  C. Swap axes
  D. Create Presentations
  A. Create data by members and tables

• Question 160:

  You use ABAP database connectivity (ADBC) to issue native SQL calls to the database, the native SQL call.

  Which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call? Please choose the correct answer.

  A. SET_PARAM_TABLE
  B. SET_PARAM
  C. EXECUTE_QUERY
  D. NEXT_PACKAGE
  D. NEXT_PACKAGE

  ---

  Explanation/Reference: