C_HANADEV_17 Practice Questions Preview

Question 1

Single choice

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

A
SAP Software Download Center
B
SAP Cloud Appliance Library
C
Download Manager
D
SAP HANA Lifecycle Management

Reveal answer details Close answer details

Correct answerD

Question 2

Multiple choice

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.

A
Synchronize source with GIT repository
B
Store source in SAP HANA repository
C
Activate artifacts via_SYS_REPO
D
Create an MTA project
E
Export project as MTA archive

Reveal answer details Close answer details

Correct answersA, D, E

Question 3

Single choice

You need to create a native SAP HANA application that fully leverages the SAP HANA platform.

How do you implement data-intensive calculations?

A
Push the calculations onto the database layer
B
Push the calculations onto the application layer
C
Push the calculations onto the presentation layer
D
Distribute calculations between application layer and presentation layer

Reveal answer details Close answer details

Correct answerA

Question 4

Multiple choice

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
SAP HANA database version
B
Namespace
C
Template
D
Project name

Reveal answer details Close answer details

Correct answersB, D

Question 5

Multiple choice

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 to this question.

A
advanced Command Line client tool
B
XS advanced Controller Start Screen
C
Organization and Space Management tool
D
Runtime tool

Reveal answer details Close answer details

Correct answersA, B

Question 6

Multiple choice

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

A
It retrieves a high data volume from a database.
B
It increases performance by parallel execution of complex SQL statements.
C
It contains a well-defined ANSI standard.
D
It enables modular parameterized programing.

Reveal answer details Close answer details

Correct answersB, D

Question 7

Single choice

You configure an OData service for a transactional SAPUI5 application.

What is the default data access behavior of the OData service?

A
Read: Yes Create: No Update. Yes Delete No
B
Read: Yes Create: Yes Update: Yes Delete. No
C
Read: Yes Create: No Update: No Delete: No
D
Read: Yes Create: Yes Update: Yes Delete: Yes

Reveal answer details Close answer details

Correct answerD

Question 8

Single choice

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 .hdbtabledata
C
A file with extension .hdbtable
D
A file with extension .hdbdd

Reveal answer details Close answer details

Correct answerA

Question 9

Multiple choice

Which GIT commands are available with the SAP Web IDE for SAP HANA? Note: There are 3 correct answers to this question.

A
Redeploy the code
B
Clone a repository
C
Merge changes
D
Push code
E
Test changes

Reveal answer details Close answer details

Correct answersB, C, D

Question 10

Single choice

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

A
Service_url parameter of the mta.xml file
B
Start parameter of the package.json file
C
Runners parameter of the projectjson file
D
Welcome file parameter of the xs-app.json file

Reveal answer details Close answer details

Correct answerD

Question 11

Multiple choice

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

A
Re-prioritize with Workload Management.
B
Change the data model.
C
Use CE functions.
D
Modify SQL hints.

Reveal answer details Close answer details

Correct answersB, D

Question 12

Single choice

Which configuration file indicates the program that is executed upon startup when you run the Node.js module?

A
mta.yaml
B
project.json
C
package.json
D
server.js

Reveal answer details Close answer details

Correct answerC

Question 13

Multiple choice

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
Export the project as an MTA archive.
B
Store the source in the SAP HANA repository.
C
Create an MTA project.
D
Activate artifacts via_SYS_REPO.

Reveal answer details Close answer details

Correct answersA, C

Question 14

Multiple choice

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.

A
INSERT
B
POST
C
GET
D
READ

Reveal answer details Close answer details

Correct answersB, C

Question 15

Multiple choice

You need to debug a Node.js application using SAP Web IDE for SAP HANA.
What must you do?
Note: There are 3 correct answers to this question.

A
Open the debugger.
B
Attach debugger to the node module.
C
Specify the proper GIT repository in the debug properties.
D
Set a breakpoint in the application.
E
Build the application with the debug option.

Reveal answer details Close answer details

Correct answersA, B, D

Question 16

Single choice

Which OData service do you use to prevent changes to existing line items of the sap.test::myTable table?

A
service {"sap.test: :myTable" update exclude;}
B
service {"sap.test: :myTable" update no-authorization;}
C
service {"sap.test::myTable" update forbidden;}
D
service {"sap.test::myTable" update prohibited;}

Reveal answer details Close answer details

Correct answerC

Question 17

Single choice

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

A
The corresponding runtime object is created in the database module of the multi-target application
during runtime.
B
The corresponding runtime object is created in the HDI container on deployment.
C
A descriptive representation of the object is created in HDI during runtime.
D
The HDI container is created when the design-time object is saved.

Reveal answer details Close answer details

Correct answerD

Question 18

Single choice

Which tool do you use to create a calculation view in a multi-target application?

A
SAP HANA database explorer
B
SAP HANA studio
C
SAP HANA Web-based Delopment Workbench
D
SAP web IDE for SAP HANA

Reveal answer details Close answer details

Correct answerD

Question 19

Multiple choice

Which parameters do you need for the APPLY_FILTER function? Note: There are 2 correct answers to this question.

A
Filter condition
B
Dataset
C
Join condition
D
Entity set

Reveal answer details Close answer details

Correct answersA, B