SAP E_HANAAW_18 Exam Questions Instant Access

Question 1

Which of the following takes advantage of the computing power of multiple CPUs used by SAP HANA?

ADatabase table compression

BDictionary encoding

CParallel processing

DColumnar data storage

Answer : C

Question 2

You are using ABAP Development Tools, and you have placed your cursor on a method name in a class. What key do you use to navigate between a method definition and its implementation?

AF2

BF3

CF4

DF1

Answer : B

Question 3

You import an ABAP workbench request into an SAP system P81. The ABAP workbench request contains a single SAP HANA view CA_CUSTOMER that belongs to SAP HANA content package ZHA400_00. Which prerequisites are mandatory for an implicit deployment of the SAP HANA view onto the database? Note: There are 2 correct answers to this question.

AView CA_CUSTOMER has deployment mode A.

BPackage ZHA400_00 has deployment mode A.

CSystem P81 has SAP HANA as primary database.

DPackage ZHA400_00 is listed in table SNHI DUP PREWORK.

Answer : C, D

Question 4

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

ACapture the SQL profile of an application.

BSearch for problematic SELECT * statements.

CCombine static and dynamic performance analysis results.

DDisplay the execution plan of an SQL statement.

Answer : A

Question 5

Which step of the Guided Performance Analysis should you perform in the production system?

AExecuting a check run with ABAP Test Cockpit (ATC)

BCollecting data with SQL Monitor (SQLM)

CPerforming an inspection with Code Inspector (SCI)

DBuilding a work list with SQL Performance Tuning Worklist (SWLT)

Answer : B

Question 6

Why would you implement Smart Data Access (SDA)?

ATo replicate data between SAP ECC and SAP HANA

BTo define caching rules based on usage patterns

CTo generate delta images when sources cannot provide this function

DTo provide real-time access to remote data sources

Answer : A

Question 7

You want to execute a native SQL statement in your program. Why should you use ABAP Database Connectivity (ADBC)? Note: There are 2 correct answers to this question.

AIt supports locking and commit handling.

BIt has syntax check at compile time.

CIt supports exception handling.

DIt supports where-used list.

Answer : C, D

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 E_HANAAW_18 Exam Questions