SAP E_HANAAW_17 Online Practice Questions and Exam Preparation

SAP E_HANAAW_17 Online Questions & Answers

• Question 61:

  What are the two types of editors available in ADT? There are 2 correct answers to this question.

  A. Eclipse (native)
  B. Client (native)
  C. SAP (GUI)
  D. ABAP (native)
  A. Eclipse (native)
  C. SAP (GUI)

• Question 62:

  What are the features associated with ABAP CDS? There are 3 correct answers to this question.

  A. Create
  B. Export
  C. Update
  D. Read
  E. Distribution
  A. Create
  C. Update
  D. Read

• Question 63:

  Which of the following ABAP language elements are mandatory for the implementation of a method as an ABAP Managed Database Procedure? 3 answers

  A. FOR db (db = HDB...)
  B. LANGUAGE dbjang (dbjang = SQLSCRIPT...)
  C. BY DATABASE PROCEDURE
  D. CLIENT SPECIFIED
  E. AUTHORIZATION db_auth (db_auth = SYSTEM ...)
  A. FOR db (db = HDB...)
  B. LANGUAGE dbjang (dbjang = SQLSCRIPT...)
  C. BY DATABASE PROCEDURE

• Question 64:

  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

• Question 65:

  What are the key points that should be kept in mind while performing the Non-automatic update in SAP HANATr.Cont.? There are 2 correct answers to this question.

  A. Automatic release of units
  B. Changes to Delta Container
  C. You need to refresh the content of the container manually
  D. Take snapshot manually before releasing of the container
  C. You need to refresh the content of the container manually
  D. Take snapshot manually before releasing of the container

• Question 66:

  What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question

  A. Fewer data duplication and movement
  B. Exploit structured contents in SQL
  C. Easy to use modeling tool
  D. Large number of toolkits are available
  A. Fewer data duplication and movement
  C. Easy to use modeling tool

• Question 67:

  What are the steps that supported several tools, which in total result in a Guided Performance Optimization? There are 2 correct answers to this question.

  A. Tools analyzing performance at run-time, to determine if critical constructs
  B. A new tool called SQL Monitor to determine the priority if different programs access the database intensively
  C. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues.
  D. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption
  A. Tools analyzing performance at run-time, to determine if critical constructs
  B. A new tool called SQL Monitor to determine the priority if different programs access the database intensively

• Question 68:

  You create a check variant in the Code Inspector which includes the check 'Search problematic Select * statements'. SAP HANA is used as the db.

  In the check parameters, which value would you use for the percentage of fields that are effectively used?

  Please choose the correct answer.

  A. A value that you calculate based on the number of tables
  B. A higher value than on a traditional, row-store only based database
  C. A lower value than on a traditional, row-store only based database
  D. The same value as on a traditional, row-store only based database
  C. A lower value than on a traditional, row-store only based database

• Question 69:

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

  Which JOIN types can be used in the definition of a Core Data Services (CDS) view? 2 answers

  A. LEFT OUTER JOIN
  B. CROSS JOIN
  C. FULL OUTER JOIN
  D. RIGHT OUTER JOIN
  E. REFERENTIAL JOIN
  A. LEFT OUTER JOIN
  D. RIGHT OUTER JOIN