SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 41:

  Which functional problem can you detect when using the Runtime Check Monitor (SRTCM )?

  A. Existence check for secondary indexes
  B. Use of Native SQL and DB Hints
  C. Missing ORDER BY or SORT after SELECT
  D. Direct access to table pools/cluster
  C. Missing ORDER BY or SORT after SELECT

• Question 42:

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

  What can you include in the projection list of a Core Data Services (CDS) view? 3 answers

  A. ABAP system fields such as sy-langu or sy-mandt \/ CI String constants and literal values
  B. Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause
  C. A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause
  D. A field from the projection list of another CDS view used in the FROM clause
  B. Aggregation functions over fields of ABAP Dictionary tables used in the FROM clause
  C. A field from the structural output of an ABAP Managed Database Procedure used in the FROM clause
  D. A field from the projection list of another CDS view used in the FROM clause

• Question 44:

  Which Of the Golden Rules for Open SQL performance have become more important With SAP HANA? Note: There are 2 correct answers to this question.

  A. Keep unnecessary load away from the database.
  B. Minimize the number of database accesses
  C. Minimize the amount of transferred data
  D. Minimize the search overhead.
  B. Minimize the number of database accesses
  C. Minimize the amount of transferred data

• Question 45:

  You plan a database migration to SAP HANA and want to check your ABAP coding for potential functional regressions. Which Code Inspector check variant can you use?

  A. PREV_FUNC_REG
  B. FUNCTIONAL_DB
  C. FUNCTIONAL_CHECK
  D. PERFORMANCE DB
  B. FUNCTIONAL_DB

• Question 46:

  Which of the following features does the ABAP Test Cockpit offer that the ABAP code Inspector does NOT Offer? There are 2 correct answers to this question.

  A. Documented checks
  B. Enhanced distribution of results
  C. Configuration of check variants
  D. Flexible schedule of check runs
  B. Enhanced distribution of results
  D. Flexible schedule of check runs

• Question 47:

  What is the full form of HANA?

  A. High-Performance Analytic Accelerator
  B. High-Performance Analytic Application
  C. High Accelerator Numeric Analytics
  D. High-Performance Analytic Appliance
  D. High-Performance Analytic Appliance

• Question 48:

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

  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

• Question 50:

  What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

  A. Use Schema for the Connections
  B. Maintain, Monitor and test secondary database connection
  C. Maintain only HANA specific objects
  D. Used to access local or remote database system
  B. Maintain, Monitor and test secondary database connection
  D. Used to access local or remote database system