SAP Certified Development Associate - SAP HANA 2.0 SPS04 (C_HANADEV_16) Free Practice Test

Question 1

What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question.

A. Rank

B. Star join

C. Union

D. Aggregation

Correct Answer: B,D

Question 2

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

A. Project name

B. Namespace

C. SAP HANA database version

D. Template

Correct Answer: A,B

Question 3

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?

A. A file with extension .hdbti

B. A file with extension .hdbtable

C. A file with extension .hdbdd

D. A file with extension .hdbtabledata

Correct Answer: A

Question 4

Please review the JSON model in the screenshot.
Which of the following absolute binding paths are valid?
Note: There are 3 correct answers to this question.
{company: {name: "ACME", info: {employees:3}, contacts: [{name: "Barbara", phone: "873"},{name:
"Gerry", phone: '"734"}]}}

A. /company/info/employees

B. /company/contacts/1/name

C. /company/name

D. /company/contacts/2/phone

E. /contacts/0/name

Correct Answer: A,B,C

Question 5

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

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

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

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

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

Correct Answer: A

Question 6

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

A. Create an MTA project.

B. Activate artifacts via _SYS_REPO.

C. Store the source in the SAP HANA repository.

D. Export the project as an MTA archive.

Correct Answer: A,D

Question 7

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

A. Logic

B. Declarative

C. Imperative

D. Symbolic

Correct Answer: B,C

Question 8

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

A. It is created by a container-specific technical user.

B. It is logically similar to an SAP HANA schema.

C. It is the same as a tenant database.

D. It contains table and view objects.

E. It performs version management of runtime artifacts.

Correct Answer: A,B,D

Question 9

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? Note: There are 2 correct answers to this question.

A. Installation on Linux OS

B. Installation on Windows Server

C. Usage of virtual machine on Microsoft Windows

D. Installation on Mac OS

Correct Answer: A,C

Question 10

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

A. UNSET

B. ARRAY

C. SET

D. UNNEST

Correct Answer: D

Welcome to TestSimulate

SAP Certified Development Associate - SAP HANA 2.0 SPS04 (C_HANADEV_16) Free Practice Test