The Best C-HANADEV-18 Exam Study Material Premium Files and Preparation Tool (Aug-2023) [Q11-Q27]

5/5 - (2 votes)

The Best C-HANADEV-18 Exam Study Material Premium Files and Preparation Tool (Aug-2023)

Get Instant Access to C-HANADEV-18 Practice Exam Questions

QUESTION 11
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.

DPUT

READ

INSERT

POST

DGET

QUESTION 12
You need to synchronize all unsynchronized changes of the remote Git branch with a local Git branch. Which operation do you use? Please choose the correct answer.

Push

Rebase

Pull

Reset

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

Scalar user-defined function

SQL Script procedure

Table user-defined function

Scripted calculation view

QUESTION 14
Which application runtimes are currently supported by the SAP Cloud Application Programming Model? There are 2 correct answers to this question.

Node.js

Python

Java

QUESTION 15
Which of the following are characteristics of database procedures?

Database procedures can have both input and output parameters; however, a parameter CANNOT be both input and output.

Database procedures can have several output parameters, and a mix of both scalar and table types is possible.

If, in the database procedure header, you use the READS SQL DATA option, then INSERT statements are prohibited; however, dynamic SQL is allowed.

If, in the database procedure header, you use the SQL SECURITY INVOKER option, then only the owner of the procedure can start it.

QUESTION 16
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.

@sap/instance-manager

@sap/xsenv

@sap/hdbext

@sap/node-vsi

QUESTION 17
A user is dropped with the “cascade” option. The user schema also contains objects owned by other users, or on which other users have privileges. What happens to the objects? There are 2 correct answers to this question.

The objects on which other users have privileges are NOT dropped.

The objects on which other users have privileges are dropped.

The objects owned by other users are NOT dropped.

The objects owned by other users are dropped.

QUESTION 18
You need to create a native SAP HANA application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations?
Please choose the correct answer.

Push the calculations onto the application layer.

Push the calculations onto the database layer

Push the calculations onto the presentation layer.

Distribute calculations between application layer and presentation layer.

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

It enables modular parameterized programing.

lt increases performance by parallel execution of complex SQL statements.

It contains a well-defined ANSI standard.

It retrieves a high data volume from a database.

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

Organizations

Users

Applications

Processes

QUESTION 21
You need to consume a Node.js service in an SAPUI5 application. In which section of the mta.xml file do you define the variable for the exposed service?
Please choose the correct answer.

In the path section of the Node.js module

In the provides section of the Node.js module

In the properties sect on of the MTA resources

In the requires sect on of the HTML5 module

QUESTION 22
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?
Please choose the correct answer.

/Products/$metadata

/Products/’

/Products

/Products/ALL

QUESTION 23
Which of the following are characteristics of SAPUI5? There are 3 correct answers to this question.

Provides an extensibility concept

Enables responsive application design

Supports customer-specific theming

Renders the UI on the server side

Provides a device-specific user experience

QUESTION 24
In a calculation view, what are the different types of input mapping available in Table Function? There are 2 correct answers to this question.

Variable

Constant

Formula

Data Source Column

QUESTION 25
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?

Git stash

Git fetch

Git merge

Git pull

QUESTION 26
What do you reference in a role template? Please choose the correct answer.

Role Collections

Roles

Routes

Scopes

QUESTION 27
Which trace do you use to create a graphical representation of an individual SQL Statement? Please choose the correct answer.

Expensive statements trace

Performance trace