E_HANAAW_18 Practice Online

Question 1

Which task can you perform with the SQL Monitor (transaction SQLM)?

A : Capture the SQL profile of an application.

B : Search for problematic SELECT * statements.

C : Combine static and dynamic performance analysis results.

D : Display the execution plan of an SQL statement.

Answer: A

Question 2

You analyse SQL Monitor data in transaction SQLMD. You know that program X accesses database table Y. You made sure that program X was executed while the SQL Monitor collected its dat

a. But the relevant

database access is NOT listed in SQLMD.

What could be the reason?

Note: There are 3 correct answers to this question.

A : SQL Monitor was activated for a specific application server

B : SQL monitor was activated with a filter that excludes database table Y

C : The data has NOT yet been transferred to the SQL monitor database tables

D : Program X was executed in the background.

E : Database table Y is a buffered table.

Answer: A,B,C

Question 3

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

A : Create a new version of the database when the AMDP is first activated

B : Delete the obsolete versions of the database procedure synchronously

C : Delete the obsolete versions of the database procedure asynchronously

D : Create a new version of the database when the AMDP is first called

Answer: C,D

Question 4

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

Answer: B,D

Question 5

What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.

A : Open system properties

B : Administration console

C : Development properties

D : System Properties

Answer: A,B

Name:	SAP Certified Development Specialist - ABAP for SAP HANA 2.0
Exam Code:	E_HANAAW_18
Certification:	SAP Certified Development Specialist
Vendor:	SAP
Total Questions:	190
Last Updated:	May 14, 2024

Download Demo E_HANAAW_18 Dumps

Create Account

Password Recovery

E_HANAAW_18 Practice Online

Download Demo E_HANAAW_18 Dumps

Member Login

Create Account

Password Recovery

E_HANAAW_18 Practice Online