SAP Certified Development Specialist - ABAP for SAP HANA 2.0 (E-HANAAW-14) Free Practice Test

Question 1

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

A. Access to ERP tables must be restricted

B. Editing of SAP HANA data models should only be possible for "Users" of the model

C. Database administration should be restricted to skilled

D. Need to have selected users in SAP HANA for Information Management

Correct Answer: A,C

Question 2

Which of the following folder is essential to relate to Smart Data Access and also combines data from remote sources? Choose the correct answer

A. Provisioning folder

B. Security folder

C. Administration folder

D. Content folder

Correct Answer: A

Question 3

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 4

Which repository objects can you edit only in the ABAP development tools in eclipse and not in the classical abap workbench? There are 3 correct answers to this question.

A. External view

B. Database procedure proxy

C. Full text index

D. Core data services view

E. ABAP program containing new open sql

Correct Answer: A,B,D

Question 5

User STUDENT_A create and activates a design-time object. In which schema is the run object generated?
Please choose the correct answer

A. SYSTEM

B. STUDENT_A

C. _SYS_BI

D. _SYS_BIC

Correct Answer: D

Question 6

What do you have to consider if you want to use Native SQL in your ABAP programs to access an SAP HANA DB? There are 2 correct answer to this question.

A. The ABAP system check the syntax of the Native SQL statements

B. The database independency of your report can be lost

C. Client handling needs to be done explicitely in the Native SQL statement

D. Hashed or sorted tables must be used with the INTO CORRESPONDING FIELDS keyword

Correct Answer: B,C

Question 7

How will you select a preference for Validation rules? Choose the correct answer

A. Windows- SAP HANA-Modeler-Preferences-Validation Rules

B. Windows- Modeler- Preferences-SAP HANA-Validation Rules

C. Windows- Preferences-SAP HANA-Modeler-Validation Rules

D. Windows- SAP HANA-Preferences-Modeler-Validation Rules

Correct Answer: C

Question 8

What are best practices when programming in ABAP for SAP HANA? There are 2 correct answers to this question.

A. Eliminate nested SELECT statements to reduce the overall number of database accesses

B. Use repeated SELECT SINGLE statements to ensure that you only read arrow if it is really required

C. Use a column list in the SELECT clause to ensure that you only read a column if it is really required

D. Calculate aggregations using ABAP code on the application server to limit database load

Correct Answer: A,C

Question 9

You use native SQL to access the SAP HANA database. What should you do to retrieve the correct data?
There are 3 correct answers to this question.

A. Use a Comma-separated column list

B. Use the tilde symbol (-) to separate qualifier from column name

C. Explicitly handle the client field

D. Specify the database schema if it is not the user's default schema

E. Use the UP TO n ROWS addition

Correct Answer: A,C,D

Question 10

What are the benefits includes with SAP HANA Full Text Search? There are 2 correct answers to this question

A. Fewer data duplication and movement

B. Exploit structured contents in SQL

C. Large number of toolkits are available

D. Easy to use modeling tool

Correct Answer: A,D

Question 11

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. Specify the other views in which the association can be used

B. Include all fields used in the ON condition in projection list

C. Specify an alias for the target entity

D. Define the cardinality for the target entity

Correct Answer: B

Question 12

What are the Guidelines for optimizing ABAP code running on HANA? There are 3 correct answers to this question.

A. High-speed data analysis

B. DB specific properties

C. Technical settings

D. Column store

E. Open SQL settings

Correct Answer: B,C,D

Question 13

Which of the following is not involved in database table of "The NewABAP SQL Monitor-Architecture?
Choose the correct answer

A. Runtime monitor data

B. Critical data table

C. Performance data table

D. Selection data table

Correct Answer: B

Welcome to TestSimulate

SAP Certified Development Specialist - ABAP for SAP HANA 2.0 (E-HANAAW-14) Free Practice Test