New Year Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

SAP E_HANAAW_18 SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Exam Practice Test

Demo: 6 questions
Total 40 questions

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 Questions and Answers

Question 1

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.

Options:

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"

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.

Options:

A.

Flexible schedule of check runs

B.

Enhanced distribution of results

C.

Documented checks

D.

Configuration of check variants

Question 3

In a graphical calculation view, you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? Note: There are 2 correct answers to this question.

Options:

A.

Create an input parameter for the ADDRESS field.

B.

Exclude the ADDRESS field from the union.

C.

Create a restricted column for the ADDRESS field.

D.

Map the ADDRESS field to a constant value.

Question 4

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

Options:

A.

Database table compression

B.

Dictionary encoding

C.

Parallel processing

D.

Columnar data storage

Question 5

Which tools can you use to provide input data for the SQL Performance Tuning Worklist (transaction SWLT)? Note: There are 3 correct answers to this question.

Options:

A.

ABAP Test Cockpit (transaction: ATC)

B.

SQL Trace (transaction: ST05)

C.

Database Performance Monitor (transaction: DB50)

D.

SQL Monitor (transaction: SQLM)

E.

Code Inspector (transaction: SCI)

Question 6

You have created a CDS view and used alias names for some of its elements. In which of the following cases is the alias name mandatory? Note: There are 3 correct answers to this question.

Options:

A.

CASE ordertype WHEN 'A' THEN 1 ELSE 0 END AS order_type

B.

CAST( 'USD' AS abap.cuky ) AS currency_key

C.

crtdby AS created_by

D.

SUM( revenue ) AS total_revenue

E.

ASSOCIATION TO sflight AS .flights

Demo: 6 questions
Total 40 questions