SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 161:

  You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.

  A. CAST( 'USO' AS abap.cuky) AS currency_key
  B. SUM( revenue ) AS total_revenue
  C. Crtdby AS created_by
  D. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS Order_type
  E. ASSOCIATION TO sflight AS_flights
  A. CAST( 'USO' AS abap.cuky) AS currency_key
  B. SUM( revenue ) AS total_revenue
  D. CASE order type WHEN 'A' THEN 1 ELSE 0 END AS Order_type

• Question 162:

  You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data? There are 3 correct answers to this question.

  A. Use the UP TO n ROWS addition
  B. Use the tilde symbol (-) to separate qualifier from column name
  C. Use a Comma-separated column list
  D. Specify the database schema if it is not the user's default schema
  E. Explicitly handle the client field
  C. Use a Comma-separated column list
  D. Specify the database schema if it is not the user's default schema
  E. Explicitly handle the client field

• Question 163:

  What is the main benefit of the SQL Performance Tuning Worklist?

  A. It establishes a governance process for performance optimizations.
  B. It automatically translates ABAP coding to SQLScript.
  C. It allows you to correlate the results of an ABAP source code analysis with SQL runtime data.
  D. It allows you to simulate the impact of performance optimization patterns.
  C. It allows you to correlate the results of an ABAP source code analysis with SQL runtime data.

• Question 164:

  What is the central goal of using SAP HANA? Please choose the correct answer

  A. Positive Impact on Business
  B. Accelerate Performance
  C. To set Priorities for system
  D. Monitor database for record keeping
  B. Accelerate Performance

• Question 165:

  What is Core Data Services (CDS)?

  A. A collection of services that provide information about the data volumes of the SAP HANA core tables
  B. A collection of services for ABAP application programming that provide access to the core features of the SAP HANA database management system
  C. A collection of core features and services that provide data from the ABAP application server layer to the user interface
  D. A collection of domain-specific languages and services for definition and consumption of semantically rich data models
  D. A collection of domain-specific languages and services for definition and consumption of semantically rich data models

• Question 166:

  What are the principles of Using HANA Transport Containers properly? There are 3 correct answers to this question.

  A. Import of Transport Request
  B. To create Transport container of delivery unit
  C. Automatic update for all export methods
  D. Release of Transport request
  E. Takes a 'snapshot' of all SAP HANA objects of delivery unit
  A. Import of Transport Request
  D. Release of Transport request
  E. Takes a 'snapshot' of all SAP HANA objects of delivery unit

• Question 167:

  Which of the following statements are true about "Content"?

  A. It represents SAP HANA's data dictionary.
  B. It contains the design-time artifacts.
  C. All the physical tables and views can be found under the Catalog node.
  B. It contains the design-time artifacts.

• Question 168:

  What are the different types of Variables in HANA? (3 answers)

  A. Range
  B. Double
  C. Single Value
  D. Interval
  A. Range
  C. Single Value
  D. Interval

  ---

  Explanation/Reference:

• Question 169:

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

  Which recent software innovations are applied in SAP HANA? 3 answers

  A. Columnar data storage
  B. Automated de-installation at system shutdown
  C. Improved data compression algorithms
  D. Insert Only approach
  E. Random Undefined Multi-Memory Swapping (RUMMS)
  A. Columnar data storage
  C. Improved data compression algorithms
  D. Insert Only approach

  ---

  Explanation/Reference: