C_HANADEV_17 Online Practice Questions and Answers

Which URL query options are available with XSOData v2.0? Note: There are 3 correct answers to this question.

A. $top

B. $filter

C. $select

D. $view

E. $read

Which tool can you use to perform an in-place upgrade of SAP HANA 2.0, express edition?

A. SAP Software Download Center

B. SAP Cloud Appliance Library

C. Download Manager

D. SAP HANA Lifecycle Management

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

A. Push the calculations onto the database layer

B. Push the calculations onto the application layer

C. Push the calculations onto the presentation layer

D. Distribute calculations between application layer and presentation layer

You create a simple data model to store user information. The model contains two tables: One for the user information, 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 to you perform if you use CDS artifacts only?

A. Create two entities for the user and address. Extend the user entity with address columns. Create a view named User Details using select on the user entity.

B. 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 O entity. Define a User Details view using select on the address entity and using the association to read the user information.

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

For what do you use the RESIGNAL statement in SQLScript?

A. System exceptions

B. Specific SQL error codes

C. Generic SQL exceptions

D. User-defined exceptions

You need to manage an exception in a SQLScript.

Which SQLScript features can you use?

Note: There are 2 correct answers to this question.

A. CREATE EXIT HANDLER

B. DECLARE EXIT HANDLER

C. SIGNAL

D. DEFINE RESIGNAL

Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question.

A. Entity set

B. Join condition

C. Table variable

D. Filter condition

What do you use to set up unit testing for your SQL Script procedure? Please choose the correct answer.

A. A library with language SQLSCRIPTTEST

B. The SQL Script debugger

C. SQL Script logging procedures

D. The SQL Script Code Analyzer

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

A. Temporal join

B. Dynamic join

C. Text join

D. Multi join

What key words are contained in the application descriptor file (xs-app.json)? There are 2 correct answers to this question.

A. tenant-mode

B. routes

C. authentication Method

D. role-templates