SAP Certified Development Specialist - ABAP for SAP HANA 2.0 (E_HANAAW_16) Free Practice Test

Question 1

Why is not a key factor of ALV for HAN A? Please choose the correct answer.

A. To supply suitable values for any input parameters

B. To activate and execute the program in the application

C. Derived column headings from the data element

D. The data display is restricted to a maximum of 2 billion cell

Correct Answer: B

Question 2

AM DP can detect 3 types of syntax errors in active or inactive source code. What are these errors ? There are
3 correct answers to this question.

A. HANA specific syntax errors

B. UNION specific syntax errors

C. Database platform syntax errors

D. SQLScript errors

E. Database independent syntax errors

Correct Answer: A,D,E

Question 3

Which of the following tasks can you perform with SQL monitor (transaction SQLM)? There are 1 correct answer to this question.

A. Display the execution plan of an SQL statement

B. Search for problematic SELECT* statements

C. Combine static and dynamic performance analysis results

D. Capture the SQL profile of an application

Correct Answer: D

Question 4

You use the ABAP trace (SAT) to measure the run time of a program. In a class, method X checks the validity of its importing parameters and calls method Y.
What pattern of gross and net run time would you expect to see the in the ABAP trace results for method X? Please choose the correct answer.

A. The net run time is less than the gross run time

B. The gross and net run times are identical

C. The net run time is equal to Zero

D. The net run time is greater than the gross run time

Correct Answer: A

Question 5

What are the Possible Approaches with AS ABAP < 7.4 SP02? There are 2 correct answers to this question

A. Stored Procedures

B. Consume using native SQL

C. SQL units

D. Interaction with Database

Correct Answer: A,B

Question 6

Which of the following repository object can you edit only in ABAP Development tools in Eclipse and not in the Classical ABAP workbench?
There are 3 correct answers to this question.

A. ABAP program containing new Open SQL

B. External view

C. Database procedure proxy

D. Full-text index

E. Core Data service (CDS) view

Correct Answer: B,C,E

Question 7

Where can you consume associations in a Core Data Services (CDS) view? 3 ans

A. In the name list

B. In the WHERE and HAVING clauses

C. In the input parameter list

D. In the FROM clause

E. In the projection list

Correct Answer: B,D,E

Question 8

Which form of services is responsible for defining and consuming semantically rich data models? (1 ans)

A. Conditional services

B. Model-ll services

C. It services

D. Core Data Services (CDS)

Correct Answer: D

Question 9

What views will be most efficient for General Modeling Principles? There are 2 correct answers to this question

A. Column view

B. Analytical view

C. Attribute view

D. Schema view

Correct Answer: B,C

Question 10

How to call the stored procedures in ABAP code? Please choose the correct answer.

A. Native SOL

B. CDS view

C. Only SQL

D. Open SQL

Correct Answer: A

Question 11

Which of the statement is true for SAP HANA?

A. In SAP HANA all the data resides in RAM. Hence in case of power failure all the data will be lost.

B. SAP HANA also uses disc memory to keep backup. In case of power failure the database can be re-stored to the last consistent state.

Correct Answer: B

Question 12

Which of the following tools and programming techniques use the SQL data definition language? There are 2 correct answers to this question.

A. Core data services (CDS) data definition

B. ABAP Dictionary

C. Core data service (CDS) access control

D. Open SQL

Correct Answer: C,D

Question 13

When to use Enhanced Open SQL?
There are 2 correct answers to this question.

A. To access system fields

B. At the time of Dictionary Views

C. Need the query in one piece of code only

D. To view scalar components

Correct Answer: A,C

Question 14

List down the three main concepts of the SAP HANA database There are 3 correct answers to this question

A. Compression

B. Column Store

C. Partitioning

D. Object store

E. Tools combinations

Correct Answer: A,B,C

Welcome to TestSimulate

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 (E_HANAAW_16) Free Practice Test