SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 71:

  What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.

  A. Open system properties
  B. Administration console
  C. Development properties
  D. System Properties
  A. Open system properties
  B. Administration console

• Question 72:

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

  A. PERFORMANCE_OPT
  B. CHECK_PERFORMANCE
  C. FUNCTIONAL_DB
  D. PERFORMANCE_DB
  D. PERFORMANCE_DB

• Question 73:

  You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question.

  A. ABAP dictionary tables used in procedure body
  B. ABAP dictionary views used in procedure body
  C. CE function used in procedure Body
  D. AMDP Used in Procedure Body
  E. SAP HANA views used in procedure body
  A. ABAP dictionary tables used in procedure body
  C. CE function used in procedure Body
  D. AMDP Used in Procedure Body

• Question 74:

  You analyse SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its data. But the relevant database access is NOT listed in SQLMD.

  What could be the reason?

  Note: There are 3 correct answers to this question.

  A. SQL Monitor was activated for a specific application server
  B. SQL monitor was activated with a filter that excludes database table Y
  C. The data has NOT yet been transferred to the SQL monitor database tables
  D. Program X was executed in the background.
  E. Database table Y is a buffered table.
  A. SQL Monitor was activated for a specific application server
  B. SQL monitor was activated with a filter that excludes database table Y
  C. The data has NOT yet been transferred to the SQL monitor database tables

• Question 75:

  Which of the following is true? (2 correct answers)

  A. A read only procedure cannot call read-write procedure.
  B. A Read-write procedure cannot call another read-write procedure.
  C. A read-write procedure can call both read-write and read only procedures.
  A. A read only procedure cannot call read-write procedure.
  C. A read-write procedure can call both read-write and read only procedures.

• Question 76:

  In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? Please choose the correct answer.

  A. Include all fields used in the ON condition in projection list
  B. Specify an alias for the target entity
  C. Define the cardinality for the target entity
  D. Specify the other views in which the association can be used
  A. Include all fields used in the ON condition in projection list

• Question 77:

  In a Graphical calculation view you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? There are 2 correct answers to this question.

  A. Create an input parameter for the ADDRESS field
  B. Exclude the ADDRESS field from the union
  C. Create a restricted column for the ADDRESS field
  D. Map the ADDRESS field to a constant value
  B. Exclude the ADDRESS field from the union
  D. Map the ADDRESS field to a constant value

• Question 78:

  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.

• Question 79:

  Which character is used to escape host variables in the new Open SQL syntax?

  A. * (asterisk)
  B. @ (at)
  C. : (colon)
  D. ~ (tilde)
  B. @ (at)

• Question 80:

  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