SAP Certified Development Associate - SAP HANA 2.0 SPS05 (C-HANADEV-17) Free Practice Test

Question 1

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 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.

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

D. 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.

Correct Answer: C

Question 2

You implement an asynchronous Node.js service that sends requests to the database. How do you handle the database responses? There are 2 correct answers to this question.

A. Call a method directly after every send request.

B. Process the callback methods in the order in which the requests are sent by the service.

C. Register a callback method for every sent request.

D. Process the callback methods in the order in which the requests are returned from the database.

Correct Answer: C,D

Question 3

Which tool do you use to create a calculation view in a multi-target application? Please choose the correct answer.

A. SAP HANA studio

B. SAP HANA database explorer

C. SAP HANA Web-based Development Workbench

D. SAP Web IDE for SAP HANA

Correct Answer: D

Question 4

You develop an OData service using XSODATA. Which HTTP commands can you use to define the operations on the resources? There are 3 correct answers to this question.

A. POST

B. DGET

C. DPUT

D. READ

E. INSERT

Correct Answer: A,B,C

Question 5

You define exception handling in a SQL Script procedure. What can you use declare exit handlers for? There are 2 correct answers to this question.

A. Generic SQL conditions

B. Specific SQL conditions

C. Specific SQL error codes

D. Generic SQL exceptions

Correct Answer: B,C

Question 6

To perform a specific task of an XS advanced application, what does a user need? Please choose the correct answer.

A. To be assigned to a Space

B. To have directly assigned a Scope

C. To be assigned to an Organization

D. To have directly assigned a Role Collection

Correct Answer: D

Question 7

Which new components can you use to develop native SAP HANA applications in SAP HANA extended application services, advanced model (XS advanced)?
There are 2 correct answers to this question.

A. SAP HANA repository

B. Git repository

C. SAP HANA studio

D. SAP Web IDE for SAP HANA

Correct Answer: B,D

Question 8

What are the different types of graphical calculation views that can handle measures? There are 2 correct answers to this question.

A. SQL Access Only

B. Dimension

C. Cube

D. Cube with star join

Correct Answer: B,D

Question 9

You need to consume a Node.js service in an SAPUI5 application. In which section of the mta.xml file do you define the variable for the exposed service?
Please choose the correct answer.

A. In the properties sect on of the MTA resources

B. In the path section of the Node.js module

C. In the requires sect on of the HTML5 module

D. In the provides section of the Node.js module

Correct Answer: C

Question 10

Which application runtimes are currently supported by the SAP Cloud Application Programming Model?
There are 2 correct answers to this question.

A. Node.js

B. Python

C. Java

D. Go

Correct Answer: A,C

Welcome to TestSimulate

SAP Certified Development Associate - SAP HANA 2.0 SPS05 (C-HANADEV-17) Free Practice Test