C_HANADEV_17 Online Practice Questions and Answers

In an SQLScript procedure, which feature do you use to initialize IN/OUT table parameters?

A. IS_EMPTY

B. DEFAULT EMPTY

C. DEFAULT

D. SET

Which tool do you use to create a calculation view in a multi-target application?

A. SAP HANA database explorer

B. SAP HANA studio

C. SAP HANA Web-based Delopment Workbench

D. SAP web IDE for SAP HANA

You need to check user input data in your OData request. Which exit type do you use?

A. Consistency

B. Modification

C. Verification

D. Validation

You need to initially load data from a .CSV file into a Core Data Services table in SAP HANA extended application services; advanced model (XS advanced). Which file type do you create?

A. A file with extension .hdbti

B. A file with extension .hdbtabledata

C. A file with extension .hdbtable

D. A file with extension .hdbdd

Which elements can you specify with the SAP Web IDE for SAP HANA graphical editor for Core Data Services data models? Note: There are 3 correct answers to this question.

A. Context

B. Association

C. Synonym

D. Entities

E. Procedure

Which of the following models a servet-side model in the SAPUI5 context?

A. Resource

B. OData

C. JSON

D. XML

You use path expressions (associations) in your Core Data Services to combine entities instead of using SQL joins. What is a benefit to use these associations?

A. It increases the performance of the query.

B. It enforces referential constraint.

C. It improves the writability and readability of the query.

D. It invokes authorization checks on database level.

What are the disadvantages when deploying Dynamic SQL? There are 2 correct answers to this question.

A. No possibility to use SQL Script variables

B. No possibility to bind the result to a SQL Script variable

C. Additional SQL execution privileges are required

D. Limited opportunities for optimization

Which of the following elements can be part of the UI5 application's index.html file? There are 2 correct answers to this question

A. Framework Reference

B. UI-Area

C. Backend Connection

D. Bootstrap

You need to edit a database procedure. You are concerned that the version of the database procedure file you have in your local Git repository may not be synchronized with the latest version in the remote Git repository, but at this time, you do NOT want to sync the file. You only want to see the commits applied to the file in the remote repository.Which command must you use?

A. Git stash

B. Git fetch

C. Git merge

D. Git pull