C_HANADEV_17 Online Practice Questions and Answers

You must debug an existing SQLScript procedure in SAP HANA extended application services, advanced model (XS advanced). What is the valid sequence to debug the procedure?

A. 1 Select the SQLScript procedure in the project explorer, p. 2 Open the SQLScript console. 3 Set the breakpoint in the code of your SQL procedure. 4 Generate the call to the SQL procedure and execute it.

B. 1 Select the SQLScript procedure in the database explorer, p. 2 Set the debugger privilege. 3 Set the external breakpoint in the code of your SQL procedure. 4 Run the ABAP program where the SQL procedure is called in debugging mode.

C. 1 Select the ABAP program where the SQLScript procedure is called in the project explorer. p. 2 Set the external debugger privilege. 3 Set the external breakpoint in the code of your ABAP program.

4 Run the ABAP program in debugging mode.

D. 1 Select the SQLScript procedure in the database explorer. / pv 2 Specify the SQLScript debugger settings in the SQL Debugger. 3 Set the breakpoint in the code of your stored procedure. 4 Generate the call to the SQL procedure and execute it.

In your UI5 application, you need to refer to an SAPUI5 core library that is available on your SAP HANA extended application services, advanced model (XS advanced) server.

Which files must you adapt?

Note: There are 3 correct answers to this question.

A. EH metadata.xml

B. mta.yaml

C. index.html

D. xs-app.json

E. manifest, json

Which services can you use in SAP HANA 2.0, express edition? Note: There are 3 correct answers to this question.

A. Text analytics

B. Dynamic tiering

C. System replication

D. Columnar OLTP and OLAP

E. Multi-core and parallelization

You create triggers using the SQL Console. Where are the triggers stored?

A. Repository

B. Application server

C. Package

D. Catalog

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

Which parameters do you need for the APPLY_FILTER function? Note: There are 2 correct answers to this question.

A. Filter condition

B. Dataset

C. Join condition

D. Entity set

You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application. What does the mta.yaml file contain?

A. The plugin name and version for every supported file suffix

B. The Node.js package definition with dependencies and initial run configurations

C. The application global elements, modules, resources, properties , and parameters

D. The application router description with the authentication methods and access routes

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

B. POST

C. GET

D. READ

An OData service contains an entity set called Products. Which resource path do you add to the OData service URL to view all available products?

A. /Products

B. /Products/"

C. /Products/ALL

D. /Products/$metadata