SAP SAP Certifications E_HANAAW_18 Questions & Answers

• Question 61:

  Which of the following is a limitation when you create an external view? Please choose the correct answer.

  A. You must include the name of the SAP HANA view in the name of the external view.

  B. You can only use native SQL to consume the external view

  C. You must know the underlying tables and join conditions of the SAP HANA view.

  D. You must use the ABAP Development tools (ADT) TO CREATE the external view

  Correct Answer: D

• Question 62:

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

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

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

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

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

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

  You follow the Code-to-Data paradigm in your ABAP coding.

  Which of the following scenarios conflicts with the SQL performance guideline "Keep unnecessary load away from the database"?

  A. Perform business logic and aggregations on database table content, then transfer the results to the application layer.

  B. Perform join operations on database tables, then transfer the results to the application layer.

  C. Perform calculations on data transferred to the database layer, then transfer the results back to the application layer.

  D. Perform text search operations on database table content, then transfer the results to the application layer.

  Correct Answer: C