SAP SAP Certifications E_HANAAW_18 Questions & Answers

• Question 41:

  Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.

  A. Create a new version of the database when the AMDP is first activated

  B. Delete the obsolete versions of the database procedure synchronously

  C. Delete the obsolete versions of the database procedure asynchronously

  D. Create a new version of the database when the AMDP is first called

  Correct Answer: CD

• Question 42:

  What you must do when you define and implement an ABAP Managed Database Procedure AMDP? There are 3 correct answers to this question.

  A. Define all the method parameters to pass by value

  B. List all the ABAP dictionary tables used in the procedure body in the USING clause

  C. Use Scalar types for all the AMDP method parameters

  D. Specify the database system and language

  E. Mark the AMDP method as read-only

  Correct Answer: ABD

• Question 43:

  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)

  Correct Answer: BDE

• Question 44:

  How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement?

  Please choose the correct answer.

  A. As many result sets as there are input parameters in the procedure

  B. Two result sets

  C. One result set

  D. As many result sets as there are table output parameters in the procedure

  Correct Answer: C

• Question 45:

  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

  Correct Answer: C

• Question 46:

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

  A. Range

  B. Double

  C. Single Value

  D. Interval

  Correct Answer: ACD

• Question 47:

  You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the db.

  In the check parameters, which value would you use for the percentage of fields that are effectively used?

  Please choose the correct answer.

  A. A value that you calculate based on the number of tables

  B. A higher value than on a traditional, row-store only based database

  C. A lower value than on a traditional, row-store only based database

  D. The same value as on a traditional, row-store only based database

  Correct Answer: C

• Question 48:

  What are the two types of editors available in ADT? There are 2 correct answers to this question.

  A. Eclipse (native)

  B. Client (native)

  C. SAP (GUI)

  D. ABAP (native)

  Correct Answer: AC

• Question 49:

  What is the operating system supported by HANA? (2 answers)

  A. Only Windows 8

  B. Red Hat Enterprise Linux (RHEL)

  C. SUSE Linux Enterprise Server

  D. Both Linux and Window 8

  Correct Answer: BC

• Question 50:

  Which system schema contains the list of Activated and inactive Objects? 2 answers

  A. Used to access local or remote database system

  B. Maintain, Monitor and test secondary database connection

  C. Use Schema for the Connections

  D. Maintain only HANA specific objects

  Correct Answer: AB