SAP SAP Certifications E_HANAAW_17 Questions & Answers

• Question 21:

  Your ABAP program contains an Open SQL join of two client-dependent tables. You want to replace this with a native SQL SELECT statement.

  Which of the following changes to the SELECT statement can you use to retrieve the same data as before?

  There are 2 correct answers to this question

  A. Include the client field in the field list.

  B. Include the client field in the WHERE condition.

  C. Include the client field in the join condition.

  D. Use the CLIENT SPECIFIED addition.

  Correct Answer: BC

• Question 22:

  You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias?

  There are 3 correct answers to this question.

  A. CASTE Expression

  B. CASE expression

  C. Currency Conversion

  D. Nested CASE expression

  E. Unit conversion

  Correct Answer: BCE

• Question 23:

  How can you consume a Core Data Services (CDS) view? 2 answers

  A. Use the Data Preview in ABAP Development Tools for SAP NetWeaver.

  B. Use it as a data source in the FROM clause of an Open SQL query.

  C. Use the ABAP language statement WRITE and the CDS view name as the argument.

  D. Use the CDS maintenance transaction (SCDSV).

  Correct Answer: AB

• Question 24:

  Which of the below statements are true for SAP HANA Studio? (3 answers)

  A. SAP HANA Studio can be used to manage the SAP HANA database, to create and manage user authorizations, to create new or modify existing models of data etc

  B. SAP HANA Studio is an Eclipse-based, integrated development environment (IDE) that is used to develop artifacts in a HANA server.

  C. SAP HANA Studio is a client tool, which can be used to access local or remote HANA system.

  D. SAP HANA Studio is integrated in SAP GUI > 7.40

  Correct Answer: ABC

• Question 25:

  Which of the following ABAP transactions can you use to detect SQL performance optimization potential in your ABAP code? 2 answers

  A. SQLM

  B. SE09

  C. SWLT

  D. ST22

  E. SE3S

  Correct Answer: AC

• Question 26:

  In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer

  A. Code completion option

  B. Statement Template options

  C. Editor shortcut options

  D. Code formatting option

  Correct Answer: D

• Question 27:

  Which conditional expressions can be used in Core Data Services (CDS) views? 2 answers A. CASE statements in the projection list

  B. IF statements in the projection list

  C. WHILE statements in the WHERE clause

  D. COALESCE functions in the projection list

  E. CASE statements in the HAVING clause

  Correct Answer: AD

• Question 28:

  You want to move some of the logic of an ABAP program into an ABAP-managed database procedure

  (AMDP). To do so, you need to translate Open SQL statements into SAP HANA Native SQL.

  Which of the following are necessary adjustments? Note: There are 3 correct answers to this question.

  A. Replace UP TO n ROWS additions

  B. Specify the schema for every table

  C. Replace ORDER BY additions

  D. Replace CORRESPONDING FIELDS additions

  E. Add explicit client handling

  Correct Answer: ADE

• Question 29:

  What is the language SAP HANA is developed in?

  A. Assembly

  B. O

  C. C++

  D. Java

  Correct Answer: C

• Question 30:

  Which of the following statements are true about "Content"?

  A. It represents SAP HANA's data dictionary.

  B. It contains the design-time artifacts.

  C. All the physical tables and views can be found under the Catalog node.

  Correct Answer: B