SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 101:

  What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.

  A. Open system properties
  B. Administration console
  C. Development properties
  D. System Properties
  A. Open system properties
  B. Administration console

• Question 102:

  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
  B. INNER JOIN
  D. LEFT OUTER JOIN
  E. RIGHT OUTER JOIN

  ---

  Explanation/Reference:

• Question 103:

  You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer.

  A. Choose the debug as option in the context menu of the ABAP program
  B. Create a debug configuration for the ABAP application and run the program
  C. Set a breakpoint in the ABAP program and execute the program
  D. Choose the Run --> Debug options in the menu
  C. Set a breakpoint in the ABAP program and execute the program

• Question 104:

  You implement an ABAP-managed database procedure (AMDP). You want to query data from Calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb.

  How can you address the calculation view?

  Note; There are 2 correct answers to this questions.

  A. "ha400.primdb/CA_BOOKINGS_COUNT"
  B. _SYS_BIC."ha400.primdb::CA_BOOKINGS_COUNT"
  C. "ha400.primdb::CA_BOOKINGS_COUNT"
  D. _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT"
  C. "ha400.primdb::CA_BOOKINGS_COUNT"
  D. _SYS_BIC."ha400.primdb/CA_BOOKINGS_COUNT"

• Question 105:

  What are the main points of SAP HANA High Availability Per Datacenter that are available even in the event of a disaster? There are 2 correct answers to this question

  A. Active clusters for all servers
  B. Shared file systems for only one server
  C. Services-Name and index server on all nodes
  D. High availability configuration
  C. Services-Name and index server on all nodes
  D. High availability configuration

• Question 106:

  Analytic Privilege can be applied to (3 Answers)

  A. Calculation views
  B. Attribute views
  C. Analytic views
  D. Table
  E. SQL View
  A. Calculation views
  B. Attribute views
  C. Analytic views

• Question 107:

  Which is not a Golden Rule for Open SQL? Please choose the correct answer.

  A. Minimize the Number of Database Accesses
  B. Reduce the Database Load
  C. Minimize the Amount of Data Transferred
  D. Keep the result set large
  D. Keep the result set large

• Question 108:

  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
  A. May contain filters
  C. May use in calculation views
  D. Used to join tables

• Question 109:

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

  A. _SYS_REPO
  B. _SYS_BIC
  C. _SYS_BI
  D. _SYS_XS
  C. _SYS_BI

• Question 110:

  How will you hide the attributes that are not required for client consumption? Choose the correct answer

  A. By setting the hidden property flag of the attribute in the View
  B. By setting the hidden property flag of the attribute provider
  C. By setting the hidden property flag of the attribute column
  D. By setting the hidden property flag of the attribute in the Semantics screen
  D. By setting the hidden property flag of the attribute in the Semantics screen