C_HANADEV_18 by SAP Actual Free Exam Questions And Answers

Question 1

In an SQL Script procedure, which feature do you use to initialize IN/OUT table parameters? Please choose the correct answer.

A. SET

B. DEFAULT

C. DEFAULT EMPTY

D. IS_EMPTY

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 2

You need to manage an exception in a SQLScript. Which SQLScript features can you use? There are 2 correct answers to this question.

A. SIGNAL

B. DECLARE EXIT HANDLER

C. CREATE EXIT HANDLER

D. DEFINE RESIGNAL

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 3

You create a simple data model to store user information. The model contains two tables: one for the user information, and the other for user address details.
The user can only have one address. You also need a view to show the complete information of the user including the address.
Which actions do you perform if you use CDS artifacts only? Please choose the correct answer.

A. Create two entities for the user and address.
Create an association in the user entity to the address entity.
Define a User Details view using select on the address entity and using the association to read the user information.

B. Create two entities for the user and address.
Create an association in the user entity to the address entity.

C. Define a User Details view using select on the user entity and using the association to read the address information.
Create two entities for the user and address.
Extend the user entity with address columns.

D. Create a view named User Details using select on the user entity.
x-s Create two entities for the user and address.
Create a User Details calculation view and join the user and address information.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

To which SAP HANA authorization entities can you grant a role? There are 2 correct answers to this question.

A. Privilege

B. Role

C. User

D. Object

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer.

A. Multi join

B. Dynamic join

C. Temporal join

D. Text join

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question.

A. Union

B. Rank

C. Aggregation

D. Star join

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 7

What types of user-defined functions are supported by SAP HANA? Note: There are 2 correct answers to this question.

A. Scalar

B. Table

C. Aggregate

D. Hierarchy

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 8

What are the issue categories that SQL Script Code Analyser scans for? There are 3 correct answers to this question.

A. Security

B. Business logic

C. Consistency

D. Performance

E. Privileges

Discussion 0

Correct Answer: A,C,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements. On which objects can you apply the filter? There are 2 correct answers to this question.

A. Scalar variables

B. Virtual tables

C. Database tables

D. Intermediate table variables

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 10

You need to create a native SAP HANA application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations?
Please choose the correct answer.

A. Distribute calculations between application layer and presentation layer.

B. Push the calculations onto the database layer

C. Push the calculations onto the presentation layer.

D. Push the calculations onto the application layer.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

SAP Certified Development Associate - SAP HANA 2.0 SPS06 - C_HANADEV_18 Exam Practice Test

Contact Us

Useful Links

Latest Updated