SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 51:

  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
  C. Delete the obsolete versions of the database procedure asynchronously
  D. Create a new version of the database when the AMDP is first called

• Question 52:

  You import an ABAP workbench request into a SAP SYSTEM P81. The ABAP workbench request contains a single SAP HANA VIEW CA_CUSTOMER that belongs to package 2HA400_00. WHICH PREREQISITIES are mandatory for an implicit deployment of the SAP HANA view onto the database? There are 2 correct answers to this question.

  A. View CA_CUSTOMER has deployment mode A.
  B. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK
  C. SYSTEM P81 has SAP HANA has primary database
  D. PACKAGE ZHA400J30 HAS deployment Mode A
  B. Package ZHA400_00 Is listed in table SNHI_DUP_PREWORK
  C. SYSTEM P81 has SAP HANA has primary database

• Question 53:

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

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

  What are the key points that should be kept in mind while performing the Nonautomatic update in SAP HANA Transport Container? (2 answers)

  A. Changes to Delta Container
  B. You need to refresh the content of the container manually
  C. Automatic release of units
  D. Take snapshot manually before releasing of the container
  B. You need to refresh the content of the container manually
  D. Take snapshot manually before releasing of the container

  ---

  Explanation/Reference:

• Question 56:

  What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

  A. All arithmetic expressions can be used for all type of variables
  B. All ABAP variables must be escaped with a proceeding @ sign.
  C. All Keywords are case sensitive.
  D. All fields in the GROUP BY clause must be separated by commas.
  B. All ABAP variables must be escaped with a proceeding @ sign.
  D. All fields in the GROUP BY clause must be separated by commas.

• Question 57:

  Which option in SAP NetWeaver Gateway Service Builder (transaction SEGW) can be used to implement the consumption of a Core Data Services view?

  A. "Map to Data source"
  B. "Consume CDS view"
  C. "Relate to Business Entity"
  D. "Read from DDL source"
  A. "Map to Data source"

• Question 58:

  You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA. Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.

  A. Read-write
  B. Read only
  C. Write only
  D. Read-update
  B. Read only

  ---

  Explanation/Reference:

• Question 59:

  What is the scope of the AbapCatalog.Buffering annotation in a Core Data Services (CDS) view?

  A. The set of key fields specified in the additional annotation AbapCatalog.buffering.numberOfKeyFie
  B. The CDS views used in the FROM clause
  C. The entire CDS view
  D. The elements in the projection list of the CDS view
  C. The entire CDS view

• Question 60:

  You have an SQLScript procedure with a table input parameter it_books. You want to use the parameter on the right-hand side of an assignment operator within the procedure. How do you refer to the parameter? Please choose the correct answer.

  A. :it_books
  B. it_books
  C. {it.books}
  D. @it_books
  A. :it_books