SAP HANA 2.0 SPS05 C_HANADEV_17 Questions and Answers

dumps2022-04-04T02:38:00+08:00

SAP HANA 2.0 SPS05 C_HANADEV_17 questions and answers are your best choice to pass this SAP exam. There are 80 questions in real SAP HANA 2.0 SPS05 C_HANADEV_17 exam, and you have 180 minutes to take the test. The cut score is 64%. The available language is English. Free SAP HANA 2.0 SPS05 C_HANADEV_17 exam questions and answers are below.

Page 1 of 4

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

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

Import

Storage Type

Index

Association

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

What must you append to the service URL?

$servicedefinition

$schema

$metadata

$format

3. Which tool can you use to perform an in-place upgrade of SAP HANA 2.0, express edition?

SAP Software Download Center

SAP Cloud Appliance Library

Download Manager

SAP HANA Lifecycle Management

4. Which of the following activities are part of the development lifecycle using SAP HANA extended application services, advanced model (XS advanced)? Note: There are 3 correct answers to this question.

Synchronize source with GIT repository

Store source in SAP HANA repository

Activate artifacts via _SYS_REPO

Create an MTA project

Export project as MTA archive

5. Which GIT command do you use to consolidate all changes from one branch with another branch using a single commit?

Commit

Push

Rebase

Merge

6. You need to restrict the selected columns exposed to the client .

Which OData capability do you use?

Parameter entity sets

Key specification

Aggregation

Property projection

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

XSEngine

Join Engine

OLAP Engine

Java Engine

Calculation Engine

8. Which are the artifacts that are contained in an SAP HANA Deployment Infrastructure (HDI) container? Note: There are 2 correct answers to this question.

JavaScript programs

Data services

SQL Script procedures

Table definitions

9. 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 owned by other users are NOT dropped.

The objects owned by other users are dropped.

The objects on which other users have privileges are dropped.

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

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

Repository

Application server

Package

Catalog

Page 2 of 4

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

Entity set

Join condition

Table variable

Filter condition

12. Which functionality is provided by SAP web IDE for SAP HANA? Note: There are 2 correct answers to this question.

Syntax-aware editors for code

Organization and space management

Build and deploy applications

User management

13. What are the characteristics of the calculation view of type "SQL Access Only"? There are 2 correct answers to this question.

Can be directly used for multidimensional analysis

Can be direct y accessed via SQL

Can be directly exposed to all client tools

Can be directly used as modeled data source for another view

14. Which content can you include in a Node.js module of the multi-target application? Note:

There are 3 correct answers to this question.

Data services in Java

Node apps

XSJS apps

Java apps

OData services in JavaScript

15. What are some of the benefits of developing applications on SAP HANA? Note: There are 2 correct answers to this question.

Execution of stored procedures is faster due to the in-memory database.

Reliable segregation of OLAP and OLTP workloads on different SAP HANA databases.

Faster response times by using SAP HANA integrated UI rendering.

HTML5-compliant Web-based user interface is supported.

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

Text analytics

Dynamic tiering

System replication

Columnar OLTP and OLAP

Multi-core and parallelization

17. Which of the following are characteristics of an SAP HANA Deployment Infrastructure container? Note: There are 3 correct answers to this question.

It is the same as a tenant database.

It is logically similar to an SAP HANA schema.

It contains table and view objects.

It performs version management of runtime artifacts.

It is created by a container-specific technical user.

18. Which programming paradigms are supported by SQL Script? Note: There are 2 correct answers to this question.

Symbolic

Declarative

Logic

Imperative

19. What happens if you define a database object in the persistence model and deploy it using the SAP HANA Deployment Infrastructure (HDI)?

The corresponding runtime object is created in the database module of the multi-target application during runtime.

The corresponding runtime object is created in the HDI container on deployment.

A descriptive representation of the object is created in HDI during runtime.

The HDI container is created when the design-time object is saved.

20. For what do you use the RESIGNAL statement in SQLScript?

System exceptions

Specific SQL error codes

Generic SQL exceptions

User-defined exceptions

Page 3 of 4

21. Which parameter do you adapt to change the file that is initially delivered by an HTML5 module? Please choose the correct answer.

Service_url parameter of the mta.xml file

Start parameter of the package.json file

Runners parameter of the projectjson file

Welcome file parameter of the xs-app.json file

22. You use APPLY_FILTER to add a dynamic WHERE clause on SELECT statements.

On which objects can you apply the filter? Note: There are 2 correct answers to this question.

Database tables

Intermediate table variables

Virtual tables

Scalar variables

23. Which metadata declarations can you specify in an SQL Script procedure when you use the SAP HANA Deployment Infrastructure? Note: There are 2 correct answers to this question.

Authorization

Default schema

Security

Language

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

subfolder

mixinTypes

hdbtable

name

25. What do you use to set up unit testing for your SQL Script procedure? Please choose the correct answer.

A library with language SQLSCRIPTTEST

The SQL Script debugger

SQL Script logging procedures

The SQL Script Code Analyzer

26. How do you specify the target currency for currency conversion in calculation views? There are 3 correct answers to this question.

With an input parameter

With a fixed value

In a column

In a procedure

In a table function

27. Who owns the database objects created in an SAP HANA Deployment Infrastructure container?

The generated, container-specific technical user

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

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!

28. You implement a native SAP HANA application using SAP HANA extended application services, advanced mode (XS advanced) and SAPUI5.

Where is the UI rendering executed?

On the XSadvanced application server

On the SAPUI5 HTML5 module

On the front-end client device

On the SAP Fiori front-end server

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

Role

Privilege

Object

User

30. Your multi-target application will use XSJS .

Which module type do you create in your application project? Please choose the correct answer.

SAP HANA database

HTML5

Java

Node.js

Page 4 of 4

31. You need to check user input data in your OData request .

Which exit type do you use?

Consistency

Modification

Verification

Validation

32. You develop native SAP HANA applications in SAP HANA extended application services, advanced model (XS advanced).

What are some of the advantages compared to developing in SAP HANA extended application services, classic model (XS classic)? Note: There are 3 correct answers to this question.

No additional SAP HANA components are required.

It supports different runtime containers.

The source code repository is built into the SAP HANA database.

Advanced GIT/GERRIT source code management is available.

The application layer can be separate from the database.

33. You need to manage an exception in a SQL Script.

Which SQL Script features can you use? Note: There are 2 correct answers to this question.

CREATE EXIT HANDLER

DECLARE EXIT HANDLER

SIGNAL

DEFINE RESIGNAL

34. Which artifacts do you define in the persistence model to access objects in an external SAP HANA Deployment Infrastructure container?

Imports

Synonyms

Views

Procedures

35. Where do you add controls to the user interface?

JSON model

OData model

XML view

Manifest file

SAP HANA 2.0 SPS05 C_HANADEV_17 Questions and Answers

SAP HANA 2.0 SPS05 C_HANADEV_17 Questions and Answers

Share this post

Leave a Reply Cancel reply

Related Posts