Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

SAP C_HANADEV_17 Dumps

SAP Certified Development Associate - SAP HANA 2.0 SPS05 Questions and Answers

Question 1

Which Git commands are available with the SAP Web IDE for SAP HANA? There are 3 correct answers to this question.

Options:

A.

Test changes

B.

Push code

C.

Clone a repository

D.

Redeploy the code

E.

Merge changes

Question 2

You need to access a remote database table object within your HDB module in a Multi-target application 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 Multi-target application project YAML file.

Which activities do you perform?

Options:

A.

There are 3 correct answers to this question.

B.

Create a view that refers to a synonym. n Create a synonym that refers to the view.

C.

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

D.

Create a synonym for the remote table object.

E.

Create a view that refers to the table.

Question 3

Which activities do you perform on an application in the SAP HANA XS Advanced Cockpit? There are 2 correct answers to this question.

Options:

A.

Monitor applications assigned to the current space.

B.

Deploy applications to SAP Cloud Platform.

C.

Display HDI container content.

D.

Start, stop, and restart applications.

Question 4

Why do you use associations in your persistence model for SAP HANA extended application services, advanced model (XS advanced)? Please choose the correct answer.

Options:

A.

To enforce database-level constraints

B.

To define the relationships between contexts and views

C.

To define multiplicity and key of an entity relation

D.

To set relationships between multiple contexts

Question 5

From which tool can you run the XS command line? Please choose the correct answer.

Options:

A.

Local operating system shell

B.

SAP HANA studio

C.

SAP WeblDE for SAP HANA

D.

SAP HANA cockpit

Question 6

What are the main SAP HANA engines responsible for executing calculation views? There are 3 correct answers to this question.

Options:

A.

Java Engine

B.

XS Engine

C.

OLAP Engine

D.

Calculation Engine

E.

Join Engine

Question 7

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?

There are 2 correct answers to this question.

Options:

A.

@sap/instance-manager

B.

@sap/xsenv

C.

@sap/hdbext

D.

@sap/node-vsi

Question 8

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

Options:

A.

Generic SQL conditions

B.

Generic SQL exceptions

C.

Specific SQL error codes

D.

Specific SQL conditions

Question 9

In application development with XS advanced, which of the following entities belong to a specific SPACE? There are 2 correct answers to this question.

Options:

A.

Organizations

B.

Users

C.

Applications

D.

Processes

Question 10

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

Options:

A.

It enables modular parameterized programing.

B.

lt increases performance by parallel execution of complex SQL statements.

C.

It contains a well-defined ANSI standard.

D.

It retrieves a high data volume from a database.

Question 11

Which of the following SQL Script elements do you use to transform a set of arrays into an intermediate table variable? Please choose the correct answer.

Options:

A.

OSET

B.

ARRAY

C.

UNNEST

D.

UNSET

Question 12

What is the package descriptor package.json used for? There are 2 correct answers to this question.

Options:

A.

To define back-end destinations

B.

To set the router version

C.

To list the package dependencies

D.

To define the routes

Question 13

In which of the following objects can you use Commit and Rollback statements? Please choose the correct answer.

Options:

A.

Scalar user-defined function

B.

SQL Script procedure

C.

Table user-defined function

D.

Scripted calculation view