SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 91:

  You execute a Native SQL query statement to retrieve a list of information using the corresponding ABAP Database Connectivity (ADBC) API method.

  Which additional steps are necessary to retrieve the result set into an internal table? 2 answers

  A. Close the CL_SQL_STATEMENT object to release the resources.
  B. Use an Open SQL query that uses the JOIN between the result set and the internal table as a data source.
  C. Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.
  D. Fetch the result using the next_package method of class CL_SQL_RESULT_SET.
  E. Fetch the result using the fetch method of class CL_SQL_EXECUTE.
  C. Bind a reference to the internal table as an output parameter to the CL_SQL_RESULT_SET instance.
  D. Fetch the result using the next_package method of class CL_SQL_RESULT_SET.

  ---

  Explanation/Reference:

• Question 92:

  The new bottlenecks avoided by addressing two challenges, what are they? There are 2 correct answers to this question.

  A. Avoid idiling CPU cores
  B. Avoid CPU cache misses
  C. Avoid optimizing data
  D. Avoid single network
  A. Avoid idiling CPU cores
  B. Avoid CPU cache misses

• Question 93:

  Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.

  A. ABAP Dictionary
  B. Open SQL
  C. Core data services (CDS) data definition
  D. Core data services (CDS) access control
  B. Open SQL
  D. Core data services (CDS) access control

• Question 94:

  Which functional problem can you detect when using the Runtime Check Monitor (SRTCM )?

  A. Existence check for secondary indexes
  B. Use of Native SQL and DB Hints
  C. Missing ORDER BY or SORT after SELECT
  D. Direct access to table pools/cluster
  C. Missing ORDER BY or SORT after SELECT

• Question 95:

  You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional regressions. Which Code Inspector check variant can you use?

  A. PREV_FUNC_REG
  B. FUNCTIONAL_DB
  C. FUNCTIONAL_CHECK
  D. PERFORMANCE DB
  B. FUNCTIONAL_DB

• Question 96:

  SAP HANA: Delivers Across 5 Dimensions. These five dimensions lead to certain goals HANAhas to meet. What are these goals?

  There are 2 correct answers to this question.

  A. Analytical DBMS features
  B. Support for system tables
  C. High Performance and Scalability
  D. Hybrid data and management system
  C. High Performance and Scalability
  D. Hybrid data and management system

  ---

  Explanation/Reference:

• Question 97:

  Which system schema/user is the owner of all the activated objects?

  A. _SYS_XS
  B. _SYS_BI
  C. _SYS_REP0
  D. _SYS_BIC
  C. _SYS_REP0

• Question 98:

  What are some of the features available SAP List Viewer with integrated data access (SALV IDA)? There are 3 correct answers to this question.

  A. Display diagrams
  B. Double-click on rows
  C. Search in content
  D. Edit cells
  E. Group rows
  A. Display diagrams
  C. Search in content
  E. Group rows

• Question 99:

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

  What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

  A. Use native SQL to access SAP HANA built-in functions.
  B. Perform expensive calculations on the database.
  C. Aggregate data on the database, and transfer the results to the ABAP layer.
  D. Perform expensive calculations on the ABAP application server.
  E. Transfer all data from the database to the ABAP layer, and then aggregate the results.
  A. Use native SQL to access SAP HANA built-in functions.
  B. Perform expensive calculations on the database.
  C. Aggregate data on the database, and transfer the results to the ABAP layer.