SAP E_HANAAW_18 Exam Questions Instant Access

Question 1

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 2

What must you take into consideration when you use the new Open SQL syntax (available as of SAP NetWeaver 7.4 SP05)? Note: There are 2 correct answers to this question.

AAll classical open SQL statements in your program will become invalid.

BAll ABAP variables must be escaped with a preceding @ sign.

CAll fields in the GROUP BY clause must be separated by commas.

DAll arithmetic expressions can be used for all types of variables.

Answer : B, C

Question 3

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 4

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 5

In SAP HANA SQL, you want to create a table whose definition should NOT be visible in the catalog. Which of the following table types fulfill this requirement?

AHISTORY COLUMN

BGLOBAL TEMPORARY

CLOCAL TEMPORARY

DROW

Answer : C

Question 6

You implement an ABAP-managed database procedure (AMDP). Within this AMDP, you want to query data from calculation view CA_BOOKINGS_COUNT in SAP HANA content package ha400.primdb. How can you address the calculation view? Note There are 2 correct answers to this question.

A'ha400.primdb/CA_BOOKINGS_COUNT'

B'ha400.primdb: :CA_BOOKINGS_COUNT'

C_SYS_BIC.'ha400.primdb/CA_BOOKINGS_COUNT'

D_SYS_BIC.'ha400.primdb::CA_BOOKINGS_COUNT'

Answer : C, D

Question 7

You define and implement an ABAP Managed Database Procedure (AMDP). What do you have to list after the USING clause? Note: There are 3 correct answers to this question.

ASAP HANA views used in the procedure body

Bfunctions used in the procedure body

CAMDPs used in the procedure body

DABAP Dictionary tables used in the procedure body

EABAP Dictionary views used in the procedure body

Answer : C, D, E

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