Regular Free Updates C_HANADEV_18 Dumps Real Exam Questions Test Engine Jun 05, 2023 [Q31-Q54] : Valid Premium Exam : http://premium.validexam.com

NO.31 You create a simple data model to store user information. The model contains two tables: one for the user information, and the other for user address details.
The user can only have one address. You also need a view to show the complete information of the user including the address.
Which actions do you perform if you use CDS artifacts only? Please choose the correct answer.

Create two entities for the user and address.
Create an association in the user entity to the address entity.
Define a User Details view using select on the address entity and using the association to read the user information.

Create two entities for the user and address.
Create an association in the user entity to the address entity.

Define a User Details view using select on the user entity and using the association to read the address information.
Create two entities for the user and address.
Extend the user entity with address columns.

Create a view named User Details using select on the user entity.
x-s Create two entities for the user and address.
Create a User Details calculation view and join the user and address information.

NO.32 You need to install SAP HANA 2.0, express edition to develop a native SAP HANA application. Which of the following deployment options do you have?
There are 2 correct answers to this question.

Installation on Windows Server

Installation on Mac OS

Installation on Linux OS

Usage of virtual machine on Microsoft Windows

NO.33 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

NO.34 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

NO.35 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 schem a. The service is already declared in the Multi-target application project YAML file.
Which activities do you perform?

There are 3 correct answers to this question.

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

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

Create a synonym for the remote table object.

Create a view that refers to the table.

NO.36 You configure an OData service for a transactional SAPUI5 application. What is the default data access behavior of the OData service? Please choose the correct answer.

Read: Yes Create: Yes Update: Yes Delete: Yes

Read: Yes Create: Yes Update: Yes Delete: No

Read: Yes, Create: No Update: Yes Delete: No

NO.37 Which of the following can be used when implementing transaction management logic in SQLScript using savepoints? Note: There are 3 correct answers to this question.

Release savepoint

Rollback to savepoint

Savepoint

Reverse savepoint

Alter system savepoint

NO.38 You developed a multi-target application that contains only a database module. Which environment are the runtime objects created in? Please choose the correct answer.

Java Runtime Environment (JRE)

SAP HANA Runtime Tools (HRTT)

SAP Web IDE for SAP HANA

HANA Deployment Infrastructure Container

NO.39 Which keywords do you use to define an OData association? There are 3 correct answers to this question.

JOIN

DEPENDENT

UNION

MULTIPLICITY

PRINCIPAL

NO.40 To which SAP HANA authorization entities can you grant a role? There are 2 correct answers to this question.

Object

Role

Privilege

User

NO.41 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.

OSET

ARRAY

UNNEST

UNSET

NO.42 Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question.

Filter condition

Join condition

Entity set

Table variable

NO.43 Which configuration file indicates the program that is executed upon start up when you run the Node.js module? Please choose the correct answer.

package.json

project.json

server.js

mta.yaml

NO.44 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

NO.45 Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question.

SCHEMAS

TABLES

OBJECTS

ROLES

NO.46 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

NO.47 Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer.

Dynamic join

Text join

Temporal join

Multi join

NO.48 You created several database tables in a multi-target application and need to keep their names as short as possible. Which parameter of the .hdinamespace file do you set to ignore? Please choose the correct answer.

name

hdbtable

mixinTypes

subfolder

NO.49 You implement a native SAP HANA application using SAP HANA extended application services, advanced model (XS advanced) and SAPUI5. Where is the UI rendering executed? Please choose the correct answer.

On the SAPUI5 HTML5 module

On the SAP Fiori front-end server

On the front-end client device

On the XS advanced application server

NO.50 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.

NO.51 What are the different types of graphical calculation views that can handle measures? There are 2 correct answers to this question.

Cube

Dimension

SQL Access Only

Cube with star join

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

SAP HANA cockpit

SAP WeblDE for SAP HANA

Local operating system shell

SAP HANA studio

NO.53 Which join type is NOT supported by join optimization (pruning)? Please choose the correct answer.

Outer Join

Text Join

Referential Join

Inner Join

NO.54 Which tool do you use to create a calculation view in a multi-target application? Please choose the correct answer.

SAP Web IDE for SAP HANA

SAP HANA database explorer

SAP HANA Web-based Development Workbench

SAP HANA studio