SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 31:

  You are using a calculated column COUNTS within your Dimension Calculation View and an aggregation node. This is the data that goes into the aggregation node:

  A. AT Vienna 11 AT Vienna 15 DE Berlin 13 DE Berlin 13
  B. AT Vienna 11 AT Vienna 15 DE Berlin 13
  C. AT Vienna 26 DE Berlin 26
  D. AT Vienna 11 DE Berlin 13
  D. AT Vienna 11 DE Berlin 13

• Question 32:

  Which of the below has huge negative impact on performance? (2 answers)

  A. Mixing up SQL statement and CE functions
  B. Join on calculated column
  C. Inner Join
  A. Mixing up SQL statement and CE functions
  B. Join on calculated column

• Question 33:

  What are the different types of Calculation View? (2 answers)

  A. OLAP Calculation View
  B. Graphical Calculation View
  C. Scripted Calculation View
  D. Text-Based Calculation
  B. Graphical Calculation View
  C. Scripted Calculation View

• Question 34:

  Which of the following is true?

  A. ABAP
  B. OSQL
  C. Oc#
  D. Java
  B. OSQL

• Question 35:

  You want to implement business logic on the database layer.

  Which approach do you follow when implementing an ABAP Managed Database Procedure?

  A. The Left-Right approach
  B. The Near-Far approach
  C. The Top-Down approach
  D. The Inside-Out approach
  C. The Top-Down approach

• Question 36:

  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

• Question 37:

  What are the advantages of column based tables? (3 correct answers)

  A. Bigger Data Set
  B. Better Compression
  C. Better parallel Processing
  D. Faster Data Access
  B. Better Compression
  C. Better parallel Processing
  D. Faster Data Access

• Question 38:

  Which statement is true for SAP HANA?

  A. SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners
  B. SAP provides both hardware and software for SAP HANA.
  A. SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners

• Question 39:

  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

• Question 40:

  Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.

  A. Create a new version of the database when the AMDP is first activated
  B. Delete the obsolete versions of the database procedure synchronously
  C. Delete the obsolete versions of the database procedure asynchronously
  D. Create a new version of the database when the AMDP is first called
  C. Delete the obsolete versions of the database procedure asynchronously
  D. Create a new version of the database when the AMDP is first called