New Year Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

SAP C_HANADEV_17 SAP Certified Development Associate - SAP HANA 2.0 SPS05 Exam Practice Test

Page: 1 / 9
Total 91 questions

SAP Certified Development Associate - SAP HANA 2.0 SPS05 Questions and Answers

Question 1

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

Options:

A.

package.json

B.

project.json

C.

server.js

D.

mta.yaml

Question 2

You need to initially load data from a .csv file into a Core Data Services table in SAP HANA extended application services, advanced model (XS advanced). Which file type do you create? Please choose the correct answer.

Options:

A.

A file with extension .hdbtable data

B.

A fie with extension .hdbtable

C.

A file with extension .hdbdd

D.

A file with extension .hdbti

Question 3

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.

Options:

A.

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

B.

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

C.

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

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

Question 4

To perform a specific task of an XS advanced application, what does a user need? Please choose the correct answer.

Options:

A.

To have directly assigned a Role Collection

B.

To have directly assigned a Scope

C.

To be assigned to an Organization

D.

To be assigned to a Space

Question 5

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.

Options:

A.

Java Runtime Environment (JRE)

B.

SAP HANA Runtime Tools (HRTT)

C.

SAP Web IDE for SAP HANA

D.

HANA Deployment Infrastructure Container

Question 6

After reviewing the SQL Analyzer results, which of the following would you consider for optimizing the performance? There are 2 correct answers to this question.

Options:

A.

Re-prioritize with Workload Management.

B.

Use CE functions.

C.

Modify SQL hints.

D.

Change the data model.

Question 7

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

Options:

A.

Framework Reference

B.

Bootstrap

C.

Backend Connection

D.

UI-Area

Question 8

You define exception handling in a SQL Script procedure. What can you use declare exit handlers for? There are 2 correct answers to this question.

Options:

A.

Generic SQL conditions

B.

Generic SQL exceptions

C.

Specific SQL error codes

D.

Specific SQL conditions

Question 9

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.

Options:

A.

The plugin name and version for every supported file suffix

B.

The application router description with the authentication methods and access routes

C.

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

D.

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

Question 10

Which rules apply to declarative logic in SQL Script? There are 2 correct answers to this question.

Options:

A.

It supports the full set of SQL Script.

B.

It defines how data is processed.

C.

It is free of side effects.

D.

lt declares the flow of data.

Question 11

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.

Options:

A.

OSET

B.

ARRAY

C.

UNNEST

D.

UNSET

Question 12

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

service{ "sample.odata::customer" as customer" navigates ("Customer_Orders* as "toOrders); "sample.odata::salesorder" as "Orders";)

Options:

A.

Aggregation

B.

Association

C.

Key specification

D.

Join condition

Question 13

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

Options:

A.

It enables modular parameterized programing.

B.

lt increases performance by parallel execution of complex SQL statements.

C.

It contains a well-defined ANSI standard.

D.

It retrieves a high data volume from a database.

Page: 1 / 9
Total 91 questions