E_HANAAW_14 Exam Training Practice Tests (SAP Certified Development Specialist

Question 1

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

A. Product-based Profitability B. Costing-based Profitability C. Service-based profitability D. Account-based Profitability

Correct Answer: B,D

Question 2

Why is a security concept in SAP HANA required? There are 2 correct answers to this question

A. Editing of SAP HANA data models should only be possible for "Users" of the model B. Need to have selected users in SAP HANA for Information Management C. Access to ERP tables must be restricted D. Database administration should be restricted to skilled

Correct Answer: C,D

Question 3

What are the ABAP development guidelines? There are 2 correct answers to this question.

A. Improved tools for performance analysis B. Consuming Only ABAP contents for SAP HANA C. Extensions to ABAP Language D. Improved hybrid components for SAP HANA

Correct Answer: A,C

Question 4

What should you do to follow the code-to-data approach to programming? There are 3 correct answers to this question.

A. Perform expensive calculations on the ABAP application server. B. Use native SQL to access SAP HANA built-in functions. C. Transfer all data from the database to the ABAP layer, and then aggregate the results. D. Perform expensive calculations on the database. E. Aggregate data on the database, and transfer the results to the ABAP layer.

Correct Answer: B,D,E

Question 5

You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias?
There are 3 correct answers to this question.

A. Nested CASE expression B. Currency Conversion C. CASTE Expression D. CASE expression E. Unit conversion

Correct Answer: B,D,E

Question 6

How to create a core data services view? (3 ans)

A. Use SQL capabilities for Netweaver B. Use DDL statement DEFINE VIEW and SQL like syntax to define the view C. Use data services tools for updates D. Use the ABAP Development Tools for SAP Netweaver E. Use additional annotations - marked with the @sign

Correct Answer: B,D,E

Question 7

What must you take into consideration when you use the new open SQL syntax (available as of SAP Net weaver 7.4 SP05)? There are 2 correct answers to this question.

A. All fields in the GROUP BY clause must be separated by commas. B. All Keywords are case sensitive. C. All ABAP variables must be escaped with a proceeding @ sign. D. All arithmetic expressions can be used for all type of variables

Correct Answer: A,C

Question 8

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

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

Correct Answer: B

Question 9

Open SQL largely standardized, three sub-languages. What are these sub-languages? There are 3 correct answers to this question

A. Data Transferring Language(DTL) B. Data Evaluation Language(DEL) C. The Data Definition Language (DDL) D. Data Manipulation Language (DML) E. The Data Control Language (DCL)

Correct Answer: C,D,E

Question 10

You have defined the following SQLScript procedure: CREATE PROCEDURE LANGUAGE SQLSCRIPT SQL SECURITY DEFINER READS SQL DATA. Which type of database procedures can be called in this SQLScript procedure? Please choose the correct answer.

A. Read-write B. Read only C. Read-update D. Write only

Correct Answer: B

Question 11

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

A. Need the query in one piece of code only B. To access system fields C. To view scalar components D. At the time of Dictionary Views

Correct Answer: A,B

Question 12

In an ABAP Core Data services (CDS) view, what must you do expose an association for use in another CDS view? Please choose the correct answer.

A. Include all fields used in the ON condition in projection list B. Specify the other views in which the association can be used C. Define the cardinality for the target entity D. Specify an alias for the target entity

Correct Answer: A

Question 13

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

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

Correct Answer: A,B,D

Question 14

Which of the following option provides access to the views and database procedures that you can consume in the ABAP environment?

A. Open Content outlook B. Catalogue outlook C. Please choose the correct answer. D. System Perspective E. Modeler Perspective

Correct Answer: B

Question 15

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

A. Core Data Services (CDS) B. It services C. Conditional services D. Model-ll services

Correct Answer: A

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