SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 21:

  What are the Possible Approaches with AS ABAP < 7.4 SP02? There are 2 correct answers to this question

  A. SQL units
  B. Consume using native SQL
  C. Stored Procedures
  D. Interaction with Database
  B. Consume using native SQL
  C. Stored Procedures

• Question 22:

  Which of the following feature were added to the ABAP Dictionary to support the SAP HANA database? There are 3 correct answers to this question.

  A. De-pooling and de-clustering
  B. Changes of data class
  C. Definition of full-text indexes
  D. Definition of an enhancement category
  E. Storage type for tables
  A. De-pooling and de-clustering
  C. Definition of full-text indexes
  E. Storage type for tables

• Question 23:

  What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

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

• Question 24:

  Which of the following is true?

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

• Question 25:

  Which data sources can you use for SAP list viewer with integrated data access? There are 3 correct answers to this question.

  A. CDS View
  B. Database procedure
  C. External view
  D. Database Table
  E. Internal table
  A. CDS View
  C. External view
  D. Database Table

• Question 26:

  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

  ---

  Explanation/Reference:

• Question 27:

  Which of the below statements are true for SAP HANA Studio? (3 answers)

  A. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc
  B. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.
  C. SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.
  D. SAP HANA Studio is integrated in SAP GUI > 7.40
  A. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc
  B. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.
  C. SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.

  ---

  Explanation/Reference:

• Question 28:

  You want to move some of the logic of an ABAP program into an ABAP-managed database procedure (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL. Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.

  A. Replace UP TO n ROWS additions
  B. Specify the schema for every table
  C. Replace ORDER BY additions
  D. Replace CORRESPONDING FIELDS additions
  E. Add explicit client handling
  A. Replace UP TO n ROWS additions
  D. Replace CORRESPONDING FIELDS additions
  E. Add explicit client handling

  ---

  Explanation/Reference:

• Question 29:

  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.

  ---

  Explanation/Reference:

• Question 30:

  What are functions of the ABAP Managed Database Procedure (AMDP) framework? (2 answers)

  A. It deletes obsolete versions of the database procedure synchronously
  B. It deletes obsolete versions of the database procedure asynchronously
  C. It creates the database procedure when the AMDP is first called.
  D. It creates the database procedure when the AMDP is first activated.
  B. It deletes obsolete versions of the database procedure asynchronously
  C. It creates the database procedure when the AMDP is first called.

  ---

  Explanation/Reference: