SAP E_HANAAW_18 Exam Questions Instant Access

Question 1

Which functional problem can you detect when using the Runtime Check Monitor (SRTCM)?

ADirect access to Table Pools/Cluster

BMissing ORDER BY or SORT after SELECT

CUse of Native SQL and DB Hints

DExistence check for Secondary Indexes

Answer : B

Question 2

Which of the following features does the ABAP Test Cockpit offer that the ABAP Code Inspector does NOT offer? Note: There are 2 correct answers to this question.

AFlexible schedule of check runs

BEnhanced distribution of results

CDocumented checks

DConfiguration of check variants

Answer : A, B

Question 3

You are programming a report that reads data from a secondary HANA database (DB). What do you need to consider in your SQL statement? Note: There are 2 correct answers to this question.

AYou have to use native SQL when reading data from the secondary DB.

BYou have to specify the DB connection explicitly in your statement.

CYou have to specify the DB schema explicitly in your statement.

DAll tables and fields you are using must exist in the ABAP Dictionary of the secondary DB.

Answer : B, C

Question 4

Which of the Golden Rules for Open SQL Performance have become more important with SAP HANA? Note: There are 2 correct answers to this question.

AMinimize the number of database accesses.

BMinimize the amount of transferred data.

CKeep unnecessary load away from the database.

DMinimize the search overhead.

Answer : A, B

Question 5

What benefits does SAP HANA Data Compression provide? Note: There are 2 correct answers to this question.

AOptimized data partitioning

BOptimized access to column store tables

COptimized access to column store tables

DIncreased parallel processing

Answer : A, D

Question 6

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 7

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

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