SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 101:

  What are the types of schemas in HANA? (3 answers)

  A. System Defined Schema
  B. User Defined Schema
  C. SLT Derived Schema
  D. Dynamic Schema
  A. System Defined Schema
  B. User Defined Schema
  C. SLT Derived Schema

• Question 102:

  Which of the following can be part of an analytic view? (3 answers)

  A. Query transformation
  B. Logical joins
  C. Attributes
  D. Data foundation
  E. Unions
  B. Logical joins
  C. Attributes
  D. Data foundation

• Question 103:

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

  Which system schema contains the column views of activated objects?

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

• Question 105:

  Why is not a key factor of ALV for HAN A? Please choose the correct answer.

  A. The data display is restricted to a maximum of 2 billion cell
  B. To supply suitable values for any input parameters
  C. To activate and execute the program in the application
  D. Derived column headings from the data element
  C. To activate and execute the program in the application

• Question 106:

  How can you check if Core Data Services (CDS) views with scalar input parameters can be used in Open SQL queries in your system?

  A. Use the static method use_features of class cl_abap_dbfeatures.
  B. Perform a static code check using the FUNCTIONAL_DB variant.
  C. Check the Open SQL statement in the Explain SQL Statement transaction (SDBE).
  D. Check the value of the ABAP system field sy-cdsfeatures.
  A. Use the static method use_features of class cl_abap_dbfeatures.

• Question 107:

  You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? (Choose Two)

  A. It has syntax check as compile time.
  B. It supports exception handling
  C. It supports locking and commit handling
  D. It supports where-used list.
  B. It supports exception handling
  C. It supports locking and commit handling

• Question 108:

  What should you do to follow the code-to-data approach to programming? 2 answers

  A. Perform expensive calculations on the database
  B. Transfer all data from the database to the ABAP layer, and then aggregate the results.
  C. Perform expensive calculations on the ABAP application server.
  D. Aggregate data on the database, and transfer the results to the ABAP layer.
  A. Perform expensive calculations on the database
  D. Aggregate data on the database, and transfer the results to the ABAP layer.

• Question 109:

  In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog? Which of the following table types fulfill this requirement? Please choose the correct answer.

  A. ROW
  B. GLOBAL TEMPORARY
  C. COLUMN
  D. LOCAL TEMPORARY
  D. LOCAL TEMPORARY

• Question 110:

  What are the different types of Variables in HANA? (3 answers)

  A. Range
  B. Double
  C. Single Value
  D. Interval
  A. Range
  C. Single Value
  D. Interval