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

Question 1

In ADT which setting below to a specific project rather than the entire workbench. Choose the correct answer

A. Code completion option

B. Code formatting option

C. Statement Template options

D. Editor shortcut options

Correct Answer: B

Question 2

How will you hide the attributes that are not required for client consumption? Choose the correct answer

A. By setting the hidden property flag of the attribute column

B. By setting the hidden property flag of the attribute in the Semantics screen

C. By setting the hidden property flag of the attribute in the View

D. By setting the hidden property flag of the attribute provider

Correct Answer: B

Question 3

Which rules does SAP recommended to improve the performance of ABAP report on SAP HANA? There are
2 correct answers to this question.

A. Use SELECT FOR ALL ENTRIES instead of a nested SELECT statement

B. Use array variants of INSERT UPDATE MODIFY and DELETE

C. Perform all calculations and aggregations in the ABAP layer

D. Use a nested SELECT statement instead of SELECT FOR ALL ENTRIES

Correct Answer: B,D

Question 4

What are the benefits associated with The SAP HANA real-time Operational analytics? There are 2 correct answers to this question

A. Simplification of massive data

B. High modeling flexibility

C. Query Speed support

D. Fast insights into business activity

Correct Answer: B,D

Question 5

What are the two Profitability Analysis available with CO-PA Scenario in SAP HANA Modeling? There are 2 correct answers to this question

A. Service-based profitability

B. Account-based Profitability

C. Costing-based Profitability

D. Product-based Profitability

Correct Answer: B,C

Question 6

What all are the factors involved in Working with ADT.
If the search options are enabled, you can set the search parameters for an attribute of a view, which parameters will be available?
There are 3 correct answers to this question.

A. Workbench programs

B. ABAP interface

C. ABAP Class

D. Module interface

E. ABAP programs

Correct Answer: B,C,E

Question 7

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?
There are 2 correct answers to this question.

A. Create a restricted column for the ADDRESS field

B. Create an input parameter for the ADDRESS field

C. Map the ADDRESS field to a constant value

D. Exclude the ADDRESS field from the union

Correct Answer: C,D

Question 8

You define and implement an AM DP. What do you have to list after the USING clause? There are 3 correct answers to this question.

A. AMDP Used in Procedure Body

B. ABAP dictionary tables used in procedure body

C. SAP HANA views used in procedure body

D. ABAP dictionary views used in procedure body

E. CE function used in procedure Body

Correct Answer: A,B,E

Question 9

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 10

Which code-to-data capability is responsible for the Optimizations & Translation of "Open SQL SELECT FOR ALL ENTRIES clauses into native SQL?. Please choose the correct answer.

A. Buffer system Optimization

B. Database Optimization

C. HANA Specific features

D. Transparent Optimizations

Correct Answer: D

Question 11

Which steps do you have to perform when defining a view using core data services (CDS)? There are 3 correct answers to this question.

A. Use the DDL statement DEFINE VIEW and SQL like Syntax

B. Create a proxy object for the defined view.

C. Create a data definition in your ABAP package

D. Define the type mapping between ABAP and SAP HANA

E. Specify the name of the SQL view in ABAP Dictionary

Correct Answer: A,C,E

Question 12

One of your SAP systems needs to be migrated from its current database to an SAP HANA database. You want to avoid any functional issues after the migration. What should you search for and if necessary replace in the existing custom ABAP code? There are 3 correct answers to this question.

A. Left outer joins in open SQL statements

B. Code that relies on implicit database sorting

C. ORDER BY Clauses in Open SQL statements

D. Direct access to a cluster on the database

E. Native SQL statements

Correct Answer: B,D,E

Question 13

How many result sets are returned when an SAP HANA database procedure is called using the CALL WITH OVERVIEW statement?
Please choose the correct answer.

A. As many result sets as there are input parameters in the procedur

B. Two result sets

C. As many result sets as there are table output parameters in the procedure

D. One result set

Correct Answer: D

Welcome to TestSimulate

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