SAP SAP Certifications E_HANAAW_18 Questions & Answers

• Question 31:

  What is the language SAP HANA is developed in?

  A. Assembly

  B. O

  C. C++

  D. Java

  Correct Answer: C

• Question 32:

  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

• Question 33:

  You apply static code checks on your ABAP coding to find performance optimization potential and receive a message about a "Problematic SELECT * statement" issue. How can you improve the performance of your ABAP code?

  A. Use Native SQL to perform the SELECT * statement.

  B. Use the ABAP pragma ##OPTIMIZE_QUERY.

  C. Use the Open SQL SELECT RELEVANT statement.

  D. Use a field list containing only the relevant fields.

  Correct Answer: D

• Question 34:

  You have created a CDS view as follows: define view zha400 as select from spfli association (*) to sflight as_flights On spfli.carrid =_flights.carrid and spfli.connid=_flights.connid

  {

  ...

  }

  Given that table sflight also contains the field planetype, how must you address the fields carrid and planetype from table SFLIGHT?

  A. carrid and _flights.planetype

  B. _ flights.carrid and planetype

  C. carrid and planetype

  D. flights.carrid and _flight.s .planetype

  Correct Answer: A

• Question 35:

  Explain the Authorization Concept and the types of privileges associated with it? There are 3 correct answers to this question

  A. Analytic privileges

  B. Package privileges

  C. Application privileges

  D. Object privileges

  E. System privileges

  Correct Answer: ADE

• Question 36:

  You created and activated database procedure. How can you call this procedure? There are 2 correct answers to this question.

  A. By another database procedure

  B. By using Sap Analysis for Microsoft office

  C. By a script-based calculation view

  D. By a core data services view

  Correct Answer: AC

• Question 37:

  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

  Correct Answer: A

• Question 38:

  Which statement is true for SAP HANA?

  A. SAP has partnered with major hardware providers like HP, FUJITSU, CISCO, IBM, HITACHI etc. SAP only provides SAP HANA software which can run on the hardware provided by these partners

  B. SAP provides both hardware and software for SAP HANA.

  Correct Answer: A

• Question 39:

  Which system schema contains the column views of activated objects?

  A. _SYS_BI

  B. _SYS_REPO

  C. _SYS_XS

  D. _SYS_BIC

  Correct Answer: D

• Question 40:

  Discuss the main capabilities of SAP BusinessObjects Analysis for Office? There are 2 correct answers to this question

  A. Convert crosstab cells to formula

  B. Analyze data with the design pane

  C. Suggests style sets for crosstabs

  D. Sort data by characteristics

  Correct Answer: AB