SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 1:

  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
  C. One result set

• Question 2:

  Which of the following information is mandatory in the definition of an association in a Core Data Services (CDS) view?

  A. The filter condition for the association
  B. The cardinality of the association
  C. The alias for the association
  D. The target entity of the association
  D. The target entity of the association

• Question 3:

  ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question.

  A. Data Manipulation Language
  B. The Data Control Language
  C. The Database Language
  D. The Data Definition Language
  E. Data Transferred Language
  A. Data Manipulation Language
  B. The Data Control Language
  D. The Data Definition Language

• Question 4:

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

  A. _SYS_BIC
  B. _SYS_REPO
  C. _SYS_XS
  D. _SYS_BI
  B. _SYS_REPO

• Question 5:

  Which SQL syntax is used to create a read only procedure?

  A. READS SQL DATA
  B. READS PROCEDURE
  C. NO-SIDE-EFFECT
  D. READ-ONLY
  A. READS SQL DATA

• Question 6:

  Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA?

  Note: There are 2 correct answers to this question.

  A. Keep unnecessary load away from the database.
  B. Minimize the number of database accesses
  C. Minimize the amount of transferred data
  D. Minimize the search overhead.
  B. Minimize the number of database accesses
  C. Minimize the amount of transferred data

• Question 7:

  Which tools can you use to provide input data for the SQL performance tuning work list (Transaction SWLT)? There are 3 correct answers to this question.

  A. Data base performance monitor (transaction DB50)
  B. Code inspector (transaction SCI)
  C. SQL Trace (transaction ST05)
  D. SQL monitor (transaction SQLM)
  E. ABAP test cockpit (transaction ATC)
  B. Code inspector (transaction SCI)
  D. SQL monitor (transaction SQLM)
  E. ABAP test cockpit (transaction ATC)

• Question 8:

  Which of the following objects can you use in the ABAP layer when using the top-down approach to bring code to data? There are 2 correct answers to this question

  A. Calculation views
  B. ABAP managed database procedures
  C. Stored procedure
  D. Core data services views
  B. ABAP managed database procedures
  D. Core data services views

• Question 9:

  What are the features associated with ABAP CDS? There are 3 correct answers to this question.

  A. Create
  B. Export
  C. Update
  D. Read
  E. Distribution
  A. Create
  C. Update
  D. Read

• Question 10:

  What are the ABAP development guidelines? There are 2 correct answers to this question.

  A. Consuming Only ABAP contents for SAP HANA
  B. Improved tools for performance analysis
  C. Improved hybrid components for SAP HANA
  D. Extensions to ABAP Language
  B. Improved tools for performance analysis
  D. Extensions to ABAP Language