SAP SAP Certifications E_HANAAW_18 Questions & Answers

• Question 11:

  Which of the following JOIN types are supported in Open SQL? 3 answers

  A. CROSS JOIN

  B. INNER JOIN

  C. REFERENTIAL JOIN

  D. LEFT OUTER JOIN

  E. RIGHT OUTER JOIN

  Correct Answer: BDE

• Question 12:

  Which character is used to escape host variables in the new Open SQL syntax?

  A. * (asterisk)

  B. @ (at)

  C. : (colon)

  D. ~ (tilde)

  Correct Answer: B

• Question 13:

  In a Graphical calculation view you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS.

  How can you achieve this in a union node? There are 2 correct answers to this question.

  A. Create an input parameter for the ADDRESS field

  B. Exclude the ADDRESS field from the union

  C. Create a restricted column for the ADDRESS field

  D. Map the ADDRESS field to a constant value

  Correct Answer: BD

• Question 14:

  Which system schema contains the information about Time data and Schema Mapping?

  A. _SYS_REPO

  B. _SYS_BIC

  C. _SYS_BI

  D. _SYS_XS

  Correct Answer: C

• Question 15:

  Which recent software innovations are applied in SAP HANA? 3 answers

  A. Columnar data storage

  B. Automated de-installation at system shutdown

  C. Improved data compression algorithms

  D. Insert Only approach

  E. Random Undefined Multi-Memory Swapping (RUMMS)

  Correct Answer: ACD

• Question 16:

  You changed an SAP HANA object that you transported using an SAP HANA Transport container. You want to release the transport request with your changes.

  In which sequence do you perform activities in the ABAP development system immediately before the release? Please choose the correct answer.

  A. Open the SAP HANA transport containerSelect take snapshot and Save Activate the SAP HANA Transport Container

  B. Open the SAP HANA delivery unit Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container

  C. Open the ABAP transport request Select take snapshot and Save Activate the SAP HANA transport container

  D. Open the package Select take snapshot and Save Activate the SAP HANA Delivery unit Activate the SAP HANA transport container

  Correct Answer: A

• Question 17:

  What are the advantages of column based tables? (3 correct answers)

  A. Bigger Data Set

  B. Better Compression

  C. Better parallel Processing

  D. Faster Data Access

  Correct Answer: BCD

• Question 18:

  What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

  A. Use native SQL to access SAP HANA built-in functions.

  B. Perform expensive calculations on the database.

  C. Aggregate data on the database, and transfer the results to the ABAP layer.

  D. Perform expensive calculations on the ABAP application server.

  E. Transfer all data from the database to the ABAP layer, and then aggregate the results.

  Correct Answer: ABC

• Question 19:

  What is an attribute view and what are its practices? There are 3 correct answers to this question.

  A. May contain filters

  B. Used in diagrammatic Projections

  C. May use in calculation views

  D. Used to join tables

  E. May contains flow charts

  Correct Answer: ACD

• Question 20:

  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