SAP E_HANAAW_17 Exam Practice Test Instant Access

Question 1

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

AUse Schema for the Connections

BMaintain, Monitor and test secondary database connection

CMaintain only HANA specific objects

DUsed to access local or remote database system

Answer : B, D

Question 2

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.

AAutomatic release of units

BChanges to Delta Container

CYou need to refresh the content of the container manually

DTake snapshot manually before releasing of the container

Answer : C, D

Question 3

ANSI SQL owns features and adds languages. These languages divided into three parts. What are they? There are 3 correct answers to this question.

AData Manipulation Language

BThe Data Control Language

CThe Database Language

DThe Data Definition Language

EData Transferred Language

Answer : A, B, D

Question 4

What are the features of New Open SQL? There are 2 correct answers to this question.

ASupports arithmetic and string expressions

BSupports Code adjustment model

CSupports specific units of database

DSupports conditional expressions

Answer : A, D

Question 5

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are 2 correct answers to this question.

AUse SELECT FOR ALL ENTRIES instead of a nested SELECT statement

BUse array variants of INSERT UPDATE MODIFY and DELETE

CUse a nested SELECT statement instead of SELECT FOR ALL ENTRIES

DPerform all calculations and aggregations in the ABAP layer

Answer : B, C

Question 6

What are the two different kinds of Identifiers used to represent names used in SQL statement? There are 2 correct answers to this question

ADelimited identifiers

BLimited identifiers

CUndelimited Identifiers

DNumeric identifiers

Answer : A, C

Question 7

Which tasks does the ABAP managed database (AMDP) framework perform? There are 2 correct answers to this question.

ACreate a new version of the database when the AMDP is first activated

BDelete the obsolete versions of the database procedure synchronously

CDelete the obsolete versions of the database procedure asynchronously

DCreate a new version of the database when the AMDP is first called