SAP SAP Certifications E_HANAAW_17 Questions & Answers

• Question 61:

  Which components can be a part of a calculation view? (2 answers)

  A. BAPIs

  B. Analytic View

  C. Tables

  D. Attribute View

  Correct Answer: CD

• Question 62:

  What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question

  A. Fewer data duplication and movement

  B. Exploit structured contents in SQL

  C. Easy to use modeling tool

  D. Large number of toolkits are available

  Correct Answer: AC

• Question 63:

  What all are the Types of Applications based on SAP HANA? There are 2 correct answers to this question.

  A. Server based on SAP HANA

  B. Innovation based on SAP HANA

  C. New or Native SAP HANA

  D. Data Mart based on SAP HANA

  Correct Answer: CD

• Question 64:

  Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 answers

  A. FOR db (db = HDB...)

  B. LANGUAGE dbjang (dbjang = SQLSCRIPT...)

  C. BY DATABASE PROCEDURE

  D. CLIENT SPECIFIED

  E. AUTHORIZATION db_auth (db_auth = SYSTEM ...)

  Correct Answer: ABC

• Question 65:

  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

  Correct Answer: ACD

• Question 66:

  What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question

  A. Account-based Profitability

  B. Costing-based Profitability

  C. Product-based Profitability

  D. Service-based profitability

  Correct Answer: AB

• Question 67:

  What is the main benefit of the SQL Performance Tuning Worklist?

  A. It establishes a governance process for performance optimizations.

  B. It automatically translates ABAP coding to SQLScript.

  C. It allows you to correlate the results of an ABAP source code analysis with SQL runtime data.

  D. It allows you to simulate the impact of performance optimization patterns.

  Correct Answer: C

• Question 68:

  You want to implement business logic on the database layer.

  Which approach do you follow when implementing an ABAP Managed Database Procedure?

  A. The Left-Right approach

  B. The Near-Far approach

  C. The Top-Down approach

  D. The Inside-Out approach

  Correct Answer: C

• Question 69:

  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.

  Correct Answer: BD

• Question 70:

  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

  Correct Answer: B