SAP Certified Development Specialist - ABAP for SAP HANA 2.0

QUESTION NO: 1
What you must do when you define and implement an ABAP Managed Database Procedure AMDP? (3 ans) There are 3 correct answers to this question.

A. Define all the method parameters to pass by value B. List all the ABAP dictionary tables used in the procedure body in the USING clause C. Mark the AMDP method as read-only D. Use Scalar types for all the AMDP method parameters E. Specify the database system and language

Correct Answer: A,B,E

QUESTION NO: 2
Hybrid Data Management System - Combining different paradigms in one system. Discuss capabilities associated with the Hybrid Data Management system?
There are 3 correct answers to this question.

A. Text analysis and search B. Text indexing capabilities C. Built-in support for planning D. Traditional disk-based tables E. Linguistic search capabilities

Correct Answer: A,C,D

QUESTION NO: 3
Which of the following are view annotations for a CDS view? There are 3 correct answers to this question.

A. Semantics B. Client handling C. Buffering type D. Environment E. Access control

Correct Answer: B,C,E

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

A. Derived column headings from the data element B. The data display is restricted to a maximum of 2 billion cell C. To supply suitable values for any input parameters D. To activate and execute the program in the application

Correct Answer: D

QUESTION NO: 5
Which of the following tool is introduced as a holistic quality assurance tool? Choose the correct answer

A. ABAP Test Cockpit (ATC) B. DBA Cockpit C. BW system D. DBMS Cockpit

Correct Answer: A

QUESTION NO: 6
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. Create a proxy object for the defined view. B. Create a data definition in your ABAP package C. Specify the name of the SQL view in ABAP Dictionary D. Define the type mapping between ABAP and SAP HANA E. Use the DDL statement DEFINE VIEW and SQL like Syntax

Correct Answer: B,C,E

QUESTION NO: 7
Which code-to-data capability supports- Extended view definitions and Better SQL-92 standard support in open SQL? Please choose the correct answer.

A. Database oriented programming model B. Database for sophisticated analysis C. New SQL parser used in model D. SAP HANA specific features

Correct Answer: A

QUESTION NO: 8
What are the steps that supported several tools, which in total result in a Guided Performance Optimization?
There are 2 correct answers to this question.

A. A selection Code Inspector (SCI) and ABAP Test Cockpit (ATC) to locate potential functional and performance issues. B. The ABAP Trace (SAT) and the ABAP Profiling perspective to measure and compare runtime consumption C. Tools analyzing performance at run-time, to determine if critical constructs D. A new tool called SQL Monitor to determine the priority if different programs access the database intensively

Correct Answer: C,D

QUESTION NO: 9
What are the Functions of Transaction DBACOCKPIT There are 2 correct answers to this question.

A. Used to access local or remote database system B. Use Schema for the Connections C. Maintain, Monitor and test secondary database connection D. Maintain only HANA specific objects

Correct Answer: A,C

QUESTION NO: 10
You want to debug an ABAP program using ABAP development tools (ADT). How do you launch the debugger? Please choose the correct answer.

A. Create a debug configuration for the ABAP application and run the program B. Choose the debug as option in the context menu of the ABAP program C. Set a breakpoint in the ABAP program and execute the program D. Choose the Run --> Debug options in the menu

Correct Answer: C

QUESTION NO: 11
Which of the following are characteristics of an external view? There are 3 correct answers to this question.

A. It allows access to an SAP HANA information view with Open SQL. B. It is an ABAP Dictionary object type. C. It can be used as a data type in ABAP programs. D. It defines the underlying SAP HANA information view. E. It can be used in Open SQL statements for database updates.

Correct Answer: A,B,C

QUESTION NO: 12
What do you understand by the SAP HANA Software Optimization? Please choose the correct answer.

A. Huge potential for hybrid database B. Speed up the processing within the database C. Bring logic to where the data is calculated first then only move to results D. Provide combinations of objects and partitioning

Correct Answer: C

QUESTION NO: 13
In which of the following situations could a row store table be more suitable than a column store table? There are 2 correct answers to this question

A. The table contains only a small number of records. B. The table contains mainly distinct values per column across rows. C. The table contains data that you want to aggregate. D. The table contains text that you want to search.

Correct Answer: A,B

QUESTION NO: 14
Explain Transitioning ABAP Code to SAP HANA - Performance Considerations? There are 3 correct answers to this question.

A. Some codes immediately run faster B. Some codes transferred to other systems C. Classical performances recommendations for open SQL remain valid D. Some shifts in priorities, examples, nested selects(higher) indices(lower) E. Some codes impacted positively and should be priorities

Correct Answer: A,C,D

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 - E-HANAAW-14 Exam Questions