SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 81:

  What are the elements of ABAP Database Integration? There are 3 correct answers to this question.

  A. Client database handling
  B. Application server
  C. DB client-server
  D. Other DB
  E. DB For ABAP
  B. Application server
  D. Other DB
  E. DB For ABAP

• Question 82:

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

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

  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.
  D. Use a field list containing only the relevant fields.

• Question 85:

  For which purpose can you use literal values in an Open SQL statement?

  A. To perform a generic existence check
  B. To provide a default value for a database table column
  C. To alias the result of an arithmetic expression
  D. To comment your development directly in the coding
  A. To perform a generic existence check

• Question 86:

  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.
  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

• Question 87:

  Which feature can you use to improve the performance of data transformation in the Extract, Transform and Load (ETL) process?

  A. Service Adaptation Description Language (SADL)
  B. Process Agent Framework (PAF)
  C. ABAP Messaging Channels (AMC)
  D. ABAP Managed Database Procedures (AMDP)
  D. ABAP Managed Database Procedures (AMDP)

• Question 88:

  User STUDENT_A creates and activates a design-time Object. In which schema is the runtime object generated?

  A. SYS_BI
  B. SYSTEM
  C. _SYS_BIC
  D. STUDENT_A
  C. _SYS_BIC

• Question 89:

  According to the performance analysis recommendations; which steps are recommended after doing a database migration to SAP HANA?

  A. Perform regular performance scans on your ABAP custom coding as part of the development process.
  B. Perform regular performance scans on the ABAP coding delivered by SAP as part of your development process.
  C. Activate your ABAP custom coding, which was deactivated before the database migration, using U transaction SFW5.
  D. Switch the storage type of you custom database tables to column store and use the database utility (SE14) to perform the database table conversion.
  A. Perform regular performance scans on your ABAP custom coding as part of the development process.

• Question 90:

  You define and implement an ABAP Managed database procedure (AMDP). What do you have to list after the USING clause? (3 answers)

  A. ABAP Dictionary views used in the procedure body
  B. ABAP Dictionary table used in the procedure body
  C. AMDP used in the procedure body
  D. function used in the procedure body
  E. SAP HANA views used in the procedure body
  A. ABAP Dictionary views used in the procedure body
  B. ABAP Dictionary table used in the procedure body
  C. AMDP used in the procedure body

  ---

  Explanation/Reference: