SAP C_HANADEV_16 Exam (page: 5)
SAP Certified Development Associate - HANA 2.0 SPS04
Updated on: 12-Feb-2026

Viewing Page 5 of 25

You create an isolated block of code which runs as an independent transaction.
Which of the following SQLScript features do you use?

  1. Autonomous transactions
  2. Blocked transactions
  3. Anonymous transactions
  4. Anonymous transaction block

Answer(s): A



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.

  1. Specific SQL error codes
  2. Specific SQL conditions
  3. Generic SQL conditions
  4. Generic SQL exceptions

Answer(s): A,B



What are some of the advantages of SQLScript compared to plain SQL queries?
Note: There are 2 correct answers to this question.

  1. It retrieves a high data volume from a database.
  2. It increases performance by parallel execution of complex SQL statements.
  3. It contains a well-defined ANSI standard.
  4. It enables modular parameterized programing.

Answer(s): B,D



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?

  1. In the properties section of the MTA resources
  2. In the requires section of the HTML5 module
  3. In the provides section of the Node.js module
  4. In the path section of the Node.js module

Answer(s): A



Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)?
Note: There are 3 correct answers to this question.

  1. Synchronize source with GIT repository
  2. Store source in SAP HANA repository
  3. Activate artifacts via _SYS_REPO
  4. Create an MTA project
  5. Export project as MTA archive

Answer(s): A,D,E



Viewing Page 5 of 25



Share your comments for SAP C_HANADEV_16 exam with other users:

Puneeth 10/5/2023 2:06:00 AM

new to this site but i feel it is good
EUROPEAN UNION


Ashok Kumar 1/2/2024 6:53:00 AM

the correct answer to q8 is b. explanation since the mule app has a dependency, it is necessary to include project modules and dependencies to make sure the app will run successfully on the runtime on any other machine. source code of the component that the mule app is dependent of does not need to be included in the exported jar file, because the source code is not being used while executing an app. compiled code is being used instead.
Anonymous


Merry 7/30/2023 6:57:00 AM

good questions
Anonymous


VoiceofMidnight 12/17/2023 4:07:00 PM

Delayed the exam until December 29th.
UNITED STATES


Umar Ali 8/29/2023 2:59:00 PM

A and D are True
Anonymous


vel 8/28/2023 9:17:09 AM

good one with explanation
Anonymous


Gurdeep 1/18/2024 4:00:15 PM

This is one of the most useful study guides I have ever used.
CANADA