SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 81:

  According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?

  A. Perform regular performance scans on your ABAP custom coding as part of the development process.
  B. Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process.
  C. Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5.
  D. Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.
  A. Perform regular performance scans on your ABAP custom coding as part of the development process.

• Question 82:

  Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement.

  Which of the following changes to the SELECT statement can you use to retrieve the same data as before?

  There are 2 correct answers to this question

  A. Include the client field in the field list.
  B. Include the client field in the WHERE condition.
  C. Include the client field in the join condition.
  D. Use the CLIENT SPECIFIED addition.
  B. Include the client field in the WHERE condition.
  C. Include the client field in the join condition.

• Question 83:

  You follow the Code-to-Data paradigm in your ABAP coding.

  Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecessary load away from the database"?

  A. Perform business logic and aggregations on database table content, then transfer the results to the application layer.
  B. Perform join operations on database tables, then transfer the results to the application layer.
  C. Perform calculations on data transferred to the database layer, then transfer the results back to the application layer.
  D. Perform text search operations on database table content, then transfer the results to the application layer.
  C. Perform calculations on data transferred to the database layer, then transfer the results back to the application layer.

• Question 84:

  In ABAP Development Tools for SAP NetWeaver, you execute the ABAP Test Cockpit on an ABAP program to find performance optimization potential.

  Where can you find the result of the static code checks?

  A. In the Problems view
  B. In the Project Explorer view
  C. In the Performance Analysis view
  D. In the Outline view of the ABAP Performance perspective
  A. In the Problems view

• Question 85:

  What are the elements of ABAP Database Integration? There are 3 correct answers to this question.

  A. Client database handling
  B. Application server
  C. DB client-server
  D. Other DB
  E. DB For ABAP
  B. Application server
  D. Other DB
  E. DB For ABAP

• Question 86:

  AM DP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are 3 correct answers to this question.

  A. UNION specific syntax errors
  B. Database platform syntax errors
  C. Database independent syntax errors
  D. HANA specific syntax errors
  E. SQLScript errors
  C. Database independent syntax errors
  D. HANA specific syntax errors
  E. SQLScript errors

• Question 87:

  While creating a Graphical Calculation view, what are the options available in Tools palette? (4 answers)

  A. Union
  B. Cast
  C. Aggregation
  D. Projection
  E. Join
  F. Distinct
  A. Union
  C. Aggregation
  D. Projection
  E. Join

• Question 88:

  What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.

  A. Server based on SAP HANA
  B. Innovation based on SAP HANA
  C. New or Native SAP HANA
  D. Data Mart based on SAP HANA
  C. New or Native SAP HANA
  D. Data Mart based on SAP HANA

• Question 89:

  Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question

  A. Data Evaluation Language(DEL)
  B. The Data Definition Language (DDL)
  C. Data Transferring Language(DTL)
  D. The Data Control Language (DCL)
  E. Data Manipulation Language (DML)
  B. The Data Definition Language (DDL)
  D. The Data Control Language (DCL)
  E. Data Manipulation Language (DML)

• Question 90:

  Which of the following are classes of the ABAP Database Connectivity (ADBC) API? 2 answers

  A. CL_SQL_EXECUTE_QUERY
  B. CL_SQL_RESULT_SET
  C. CL_SQL_STATEMENT
  D. CL_EXEC_SQL
  E. CL_ADBC_SQL_STATEMENT
  B. CL_SQL_RESULT_SET
  C. CL_SQL_STATEMENT