E-HANAAW151 Exam Training Practice Tests (SAP Certified Development Specialist

Question 1

To upload data from flat files, SAP HANA offers several features. What are these important features?
There are 2 correct answers to this question
Response:

A. When loading new data in the table, it gets appended to the existing data B. The application suggests the column name and data type for the new tables, and it is possible to edit them C. The new table always has a 2:2 mapping between the file and table columns D. The supported file types for upload are: .cssv, .xlls, and .xlsxxx

Correct Answer: A,B

Question 2

What are the components of The Enterprise Procurement Model Demo Scenario?
There are 3 correct answers to this question.
Response:

A. Sales B. Services C. Product D. Procurement E. Stock

Correct Answer: A,D,E

Question 3

Which is not a Golden Rule for Open SQL? Please choose the correct answer. Response:

A. Reduce the Database Load B. Minimize the Number of Database Accesses C. Minimize the Amount of Data Transferred D. Keep the result set large

Correct Answer: D

Question 4

Your ABAP program contains an Open SQL join of two client-dependent tables. You want
to replace this with a native SQL SELECT statement.
Which of the following changes to the SELECT statement can you use to retrieve the same
data as before?
There are 2 correct answers to this question. Response:

A. Use the CLIENT SPECIFIED addition. B. Include the client field in the join condition. C. Include the client field in the WHERE condition. D. Include the client field in the field list.

Correct Answer: B,C

Question 5

When using ABAP Database Connectivity (ADBC) to issue native SQL calls to the database, which of the following methods of class CL_SQL_RESULT_SET retrieves the tabular result of the native SQL call?
Please choose the correct answer.
Response:

A. GET_METADATA B. SET_PARAM_TABLE C. SET_PARAM D. NEXT_PACKAGE

Correct Answer: D

Question 6

What are the supported joins in CDS view? There are 2 correct answers to this question. Response:

A. Upper join B. Left outer join C. Operators joint D. Inner join

Correct Answer: B,D

Question 7

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

A. Windows- SAP HANA-Modeler-Preferences-Validation Rules B. Windows- SAP HANA-Preferences-Modeler-Validation Rules C. Windows- Preferences-SAP HANA-Modeler-Validation Rules D. Windows- Modeler - Preferences-SAP HANA-Validation Rules

Correct Answer: C

Question 8

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

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 9

If the Search Options are enabled, you can set the Search Parameters for an attribute of a view. The following parameters are available?
There are 3 correct answers to this question
Response:

A. Index search B. Fuzzy search C. Weights for ranking D. Point base ranking E. Freestyle search

Correct Answer: B,C,E

SAP Certified Development Specialist - ABAP for SAP HANA (Edition 2015) - E-HANAAW151 Exam Practice Test