SAP HANA 2.0 SPS06 C_HANADEV_18 Exam Actual Questions

dumps2023-07-24T10:15:37+08:00

SAP HANA 2.0 SPS06 C_HANADEV_18 exam actual questions are available, which are valuable in your preparation. There are 80 questions in the real SAP certification C_HANADEV_18 exam, and you have 180 minutes to answer all the questions. The cut score for the SAP certification C_HANADEV_18 exam is 61%. The available language is English. Free SAP HANA 2.0 SPS06 C_HANADEV_18 exam actual questions are below.

Page 1 of 3

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

SCHEMAS

TABLES

OBJECTS

ROLES

2. You create an SAP HANA extended application services, advanced model (XS advanced) multi-target

application.

What does the mta.xml file contain? Please choose the correct answer.

The plugin name and version for every supported file suffix

The application router description with the authentication methods and access routes

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

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

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

It enables modular parameterized programing.

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

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

5. You work on a multi-target application that uses the SAP HANA Deployment Infrastructure (HDI).

Which operations can you perform in the SAP Web IDE for SAP HANA? There are 2 correct answers to this question.

Create objects in the SAP HANA repository.

Deploy HTML5 modules to the SAP HANA database.

Choose the supported SAP HANA versions.

Configure the artifact namespaces.

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

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

8. You created an HDI database role, using the SAP Web IDE for SAP HANA and deployed your project.

Afterward, you made some modifications to the runtime role.

What happens when you change and re-build the design-time role? Please choose the correct answer.

The runtime modifications are overwritten.

The deployment of the role fails.

The runtime modifications are kept.

You need to confirm the runtime modifications

9. You are working on an entity using Core Data Services.

Which properties can you define inside the Technical Configuration section? There are 2 correct answers to this question.

Index

Import

Storage Type

Association

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

Page 2 of 3

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

12. You need to combine data from different database tables within your OData service.

Which capability do you use for this relationship? Please choose the correct answer.

Aggregations

Projections

Associations

Entity sets

13. What key words are contained in the application descriptor file (xs-app.json)? There are 2 correct answers to this question.

routes

role-templates

tenant-mode

authentication Method

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

15. What are the disadvantages when deploying Dynamic SQL? There are 2 correct answers to this question.

Limited opportunities for optimization

No possibility to bind the result to a SQL Script variable

No possibility to use SQL Script variables

Additional SQL execution privileges are required

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

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

Local operating system shell

SAP HANA studio

SAP WeblDE for SAP HANA

SAP HANA cockpit

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.

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

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

Monitor applications assigned to the current space.

Deploy applications to SAP Cloud Platform.

Display HDI container content.

Start, stop, and restart applications.

Page 3 of 3

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

JOIN

DEPENDENT

UNION

MULTIPLICITY

PRINCIPAL

22. Which of the following elements can be part of the UI5 application's index.html file? There are 2 correct answers to this question

Framework Reference

Bootstrap

Backend Connection

UI-Area

23. In an SQL Script procedure, which feature do you use to initialize IN/OUT table parameters? Please choose the correct answer.

IS_EMPTY

DEFAULT EMPTY

DEFAULT

SET

24. Who owns the database objects created in an SAP HANA Deployment Infrastructure (HDI) container? Please choose the correct answer.

The generated, container-specific technical user

The SAP HANA extended application services, advanced model (XS advanced) user who deployed the CDS model

The database user with the generated database role, suffix ': :access_role'

The database user with the generated database role, suffix ': :external_privileges_role'

25. You want to exclusively use declarative logic in an SQL Script procedure.

Which of the following operators can you use? There are 2 correct answers to this question.

COMM IT statement

IF condition

TABLE variable

MAP_REDUCE function

26. Which elements can you specify with the SAP WeblDE for SAP HANA graphical editor for Core Data Services data models? There are 3 correct answers to this question.

Entity

Synonym

Procedure

Context

Association

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

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

28. You need to view the data model exposed by an OData V2 service.

What must you append to the service URL? Please choose the correct answer.

$schema

$service definition

$metadata

$format

29. Which of the following information must you specify when you create a new project in SAP Web IDE for SAP HANA? There are 2 correct answers to this question.

SAP HANA database version

Project name

Template

Namespace

SAP HANA 2.0 SPS06 C_HANADEV_18 Exam Actual Questions

SAP HANA 2.0 SPS06 C_HANADEV_18 Exam Actual Questions

Share this post

Leave a Reply Cancel reply

Related Posts