SAP E_HANAAW_18 Online Practice Questions and Exam Preparation

SAP E_HANAAW_18 Online Questions & Answers

• Question 121:

  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
  B. Better Compression
  C. Better parallel Processing
  D. Faster Data Access

• Question 122:

  How can you enhance an existing ABAP Search Help with a type-ahead function?

  A. Use the enhanced options in transaction SE11.
  B. Use the fuzzy-search exit in transaction SE11.
  C. Modify the search help with the Native SQL command ALTER SEARCH HELP.
  D. Enhance the lookup table with an additional ACCURACY field and insert an accuracy value.
  A. Use the enhanced options in transaction SE11.

• Question 123:

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

  What is the system privilege required to drop analytic privilege?

  A. CREATE STRUCTURED PRIVILEGE
  B. STRUCTUREDPRIVILEGE ADMIN
  C. PRIVILEGE ADMIN
  D. CREATE PRIVILEGE
  B. STRUCTUREDPRIVILEGE ADMIN

• Question 125:

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

  Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench?

  There are 3 correct answers to this question.

  A. Full-text index
  B. Database procedure proxy
  C. ABAP program containing new Open SQL
  D. Core Data service (CDS) view
  E. External view
  B. Database procedure proxy
  D. Core Data service (CDS) view
  E. External view

  ---

  Explanation/Reference:

• Question 127:

  What is the main function of Static Code Analysis? Please choose the correct answer.

  A. To detect code that would lead to functional or performance issues When migrating to SAP HANA
  B. Integrates with SAP Solution Manager
  C. Integrated into ABAP Development Tools and ABAP Workbench
  D. ABAP source code with performance optimization potential
  A. To detect code that would lead to functional or performance issues When migrating to SAP HANA

• Question 128:

  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
  A. Open the SAP HANA transport containerSelect take snapshot and Save Activate the SAP HANA Transport Container

  ---

  Explanation/Reference:

• Question 129:

  What are the steps involved in supporting a database oriented programming model? There are 2 correct answers to this question.

  A. A new and advanced Open SQL
  B. Core Data services
  C. Buffer system services
  D. Advanced and specific models
  A. A new and advanced Open SQL
  B. Core Data services

• Question 130:

  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