[May 02, 2022] Latest SAP Certified Development Associate C-HANADEV-17 Actual Free Exam Questions [Q53-Q76]

NEW QUESTION 53
What statement must you insert to the following OData service to complete the navigation definition from the customer entity set to the corresponding sales orders?
Service{ “sample.odata;; customer” as “Customer” navigates (“Customer_Orders” as
“toOrders”);”sample.odata: salesorders” as “Orders”;}

Key specification

Aggregation

Join condition

Association

NEW QUESTION 54
Which of the following SQLScript elements do you use to transform a set of arrays into an intermediate table variable?

SET

UNSET

ARRAY

UNNEST

NEW QUESTION 55
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 dueto 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.

NEW QUESTION 56
Why do you use associations in your persistence model for SAP HANA extended application services, advanced model (XS advanced)?

To enforce database-level constraints

To set relationships betweenmultiple contexts

To define multiplicity and key of an entity relation

To define the relationships between contexts and views

NEW QUESTION 57
You developnative 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.

Theapplication layer can be separate from the database.

NEW QUESTION 58
In an SAPU15 application, where do you find the reference to sap-ui-core.js?

In the URL to the SAPU15 application

In the bound attributes data model

In the manifest.json descriptor file

In the bootstrap section of the index.html

NEW QUESTION 59
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

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

Role

Privilege

Object

User

NEW QUESTION 61
You create a simple datamodel to store user information. The model contains two tables: One for the user information, 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 to you perform if you use CDS artifacts only?

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.

Create two entities for the user and address. Create a User Details calculation view and join the user and address information.

Create two entities for the user and address. Create an association in the user entity to the address O entity. Define a User Details view using select on theaddress 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 O entity. Define a User Details view using select on the user entity and using the association to read the address information.

NEW QUESTION 62
What are the key characteristics of the calculation view’s Input Parameter? There are 3 correct answers to this question.

It can NOT be used to filter measure values.

It can be used in a conditional expression.

It can be used to pass values to table functions.

It is passed via reserved word PLACEHOLDER.

It is passed using a WHERE clause.

NEW QUESTION 63
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

SQLScript procedures

Table definitions

NEW QUESTION 64
In which of the following objects can you use Commit and Rollback statements?

Table user-defined function

Scripted Calculation view

Scalar user-defined function

SQLScript procedure

NEW QUESTION 65
Which SAP HANA extended application services, advanced model (XS advanced) tools can you use to retrieve the URL for the SAP Web IDE for SAP HANA? Note: There are 2 correct answers tothis question.

advanced Command Line client tool

XS advanced Controller Start Screen

Organization and Space Management tool

Runtime tool

NEW QUESTION 66
You need to bind UI5 controls to a data source.
Between which parts of the SAPUI5 application must you create databinding?

Model and Controller

Controller and View

View and Model

Application Descriptor and View

NEW QUESTION 67
In an SQLScript procedure, which feature do you use to initialize IN/OUT table parameters?

IS_EMPTY

DEFAULT EMPTY

DEFAULT

SET

NEW QUESTION 68
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.

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

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

NEW QUESTION 69
Which of the following activities are part of the development lifecycleusing 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

NEW QUESTION 70
In your UI5application, you need to refer to an SAPUI5 core library that is available on your SAP HANA extended application services, advanced model (XS advanced) server.
Which files must you adapt?
Note: There are 3 correct answers to this question.

EHmetadata.xml

mta.yaml

index.html

xs-app.json

manifest, json

NEW QUESTION 71
You need to access a remote database table object within your HDB module in an MTA 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 MTA project YAML file.
Which activities do you perform?
Note: There are 3 correctanswers to this question.

Create a synonym that refers to the view.

Create a view that refers to a synonym.

Create a synonym for the remote table object.

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

Create a view that refers to the table.

NEW QUESTION 72
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

NEW QUESTION 73
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

NEW QUESTION 74
Which module do you use to run an SQL statement against the SAP HANA database?

@sap/xsenv

@sap/hdbext

@sap/xssec

@sap/hdi

NEW QUESTION 75
You define exception handling in a SQLScript procedure. What can you use declare exit handlers for?Note:
There are 2 correct answers to this question.

Specific SQL error codes

Specific SQL conditions

Generic SQL conditions

Generic SQL exceptions

NEW QUESTION 76
You need to combine data from different database tables within your OData service. Which capability do you use for this relationship?

Projections

Associations

Aggregations

Entity sets

Sample Questions:	SAP C-HANADEV-17 Exam Sample Question
Cut Score:	64%
Exam:	80 questions
Duration:	180 mins

[May 02, 2022] Latest SAP Certified Development Associate C-HANADEV-17 Actual Free Exam Questions [Q53-Q76]

C-HANADEV-17 Exam Certification Details:

SAP C-HANADEV-17 Exam Description:

Be the first to reply

Leave a Reply Cancel reply

C-HANADEV-17 Exam Certification Details:

SAP C-HANADEV-17 Exam Description: