C_HANADEV_17 Online Practice Questions and Answers

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

A. Specific SQL error codes

B. Specific SQL conditions

C. Generic SQL conditions

D. Generic SQL exceptions

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

A. In the properties section of the MTA resources

B. In the requires section of the HTML5 module

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

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

You need to access a remote database table object within your HDB module in an MTA project. In SAP

HANA extended application services, advanced model (XS advanced) a user-provided service was

created to access the external schema. The service is already declared in the MTA project YAML file.

Which activities do you perform?

Note: There are 3 correct answers to this question.

A. Create a synonym that refers to the view.

B. Create a view that refers to a synonym.

C. Create a synonym for the remote table object.

D. Create/update the .hdbgrants file providing authorizations for the remote schema.

E. Create a view that refers to the table.

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

A. SAP HANA studio

B. SAP HANA repository

C. GIT repository

D. SAP Web IDE for SAP HANA

Which of the following are characteristics of an SAP HANA Deployment Infrastructure container? Note: There are 3 correct answers to this question.

A. It is the same as a tenant database.

B. It is logically similar to an SAP HANA schema.

C. It contains table and view objects.

D. It performs version management of runtime artifacts.

E. It is created by a container-specific technical user.

You develop a Node.js application for the SAP HANA platform that executes a SQL statement in the SAP

HANA database.

Which modules do you use?

Note: There are 2 correct answers to this question.

A. @sap/xsenv

B. @sap/hdbext

C. @sap/node-vsi

D. @sap/instance-manager

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

A. Performance

B. Consistency

C. Security

D. Business logic

E. Privileges

You are working on an entity using Core Data Services. Which properties can you define inside the Technical Configuration section? Note: There are 2 correct answers to this question.

A. Import

B. Storage Type

C. Index

D. Association

After reviewing the SQL Analyzer results, which of the following would you consider for optimizing the performance? There are 2 correct answers to this question

A. Re-prioritize with Workload Management.

B. Change the data model.

C. Use CE functions.

D. Modify SQL hints.

You want to exclusively use declarative logic in an SQL Script procedure. Which of the following operators can you use? There are 2 correct answers to this question.

A. IF condition

B. MAP_REDUCE function

C. TABLE variable

D. COMM IT statement