SAP C_HANADEV_18 Practice Exam – 97 Unique Questions [Q57-Q78]

Rate this post

SAP C_HANADEV_18 Practice Exam – 97 Unique Questions

Latest Questions C_HANADEV_18 Guide to Prepare Free Practice Tests

SAP C_HANADEV_18 exam is an excellent opportunity for professionals who want to enhance their career in SAP HANA development. Certified Development Associate – SAP HANA 2.0 SPS06 certification validates the individual’s knowledge and expertise in developing SAP HANA solutions. It also provides a competitive edge in the job market as certified developers are in high demand.

SAP C-HANADEV-18 Certification Exam comprises 80 multiple-choice questions that need to be answered within a time limit of 180 minutes. C_HANADEV_18 exam covers various topics, including SAP HANA deployment, SAP HANA modeling, SAP HANA development, and SAP HANA troubleshooting. C_HANADEV_18 exam is available in English, Japanese, and Korean languages, and candidates need to score at least 64% to pass the exam. Certified Development Associate – SAP HANA 2.0 SPS06 certification is valid for two years, and candidates need to recertify after that period to keep their certification up-to-date.

Q57. 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.

A file with extension .hdbtable data

A fie with extension .hdbtable

A file with extension .hdbdd

A file with extension .hdbti

Q58. Which join type is NOT supported by join optimization (pruning)? Please choose the correct answer.

Outer Join

Text Join

Referential Join

Inner Join

Q59. You need to edit a database procedure. You are concerned that the version of the database procedure file you have in your local Git repository may not be synchronized with the latest version in the remote Git repository, but at this time, you do NOT want to sync the file. You only want to see the commits applied to the file in the remote repository. Which command must you use?

Git stash

Git fetch

Git merge

Git pull

Q60. Which of the following can be used when implementing transaction management logic in SQLScript using savepoints? Note: There are 3 correct answers to this question.

Release savepoint

Rollback to savepoint

Savepoint

Reverse savepoint

Alter system savepoint

Q61. 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

Welcome file parameter of the xs-app.json file

Start parameter of the package.json file

Runners parameter of the projectjson file

Q62. From which tool can you run the XS command line? Please choose the correct answer.

SAP HANA cockpit

SAP WeblDE for SAP HANA

Local operating system shell

SAP HANA studio

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

In a column

In a table function

With an input parameter

With a fixed value

In a procedure

Q64. An OData service contains an entity set called Products. Which resource path do you add to the OData service URL to view all available products?
Please choose the correct answer.

/Products/$metadata

/Products/’

/Products

/Products/ALL

Q65. You are working on an entity using Core Data Services. Which properties can you define inside the Technical Configuration section? There are 2 correct answers to this question.

Index

Import

Storage Type

Association

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

Object

Role

Privilege

User

Q67. Which new components can you use to develop native SAP HANA applications in SAP HANA extended application services, advanced model (XS advanced)?
There are 2 correct answers to this question.

SAP HANA repository

SAP HANA studio

Git repository

SAP Web IDE for SAP HANA

Q68. You need to create a native SAP HANA application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations?
Please choose the correct answer.

Push the calculations onto the application layer.

Push the calculations onto the database layer

Push the calculations onto the presentation layer.

Distribute calculations between application layer and presentation layer.

Q69. What happens if you define a database object in the persistence model and deploying using the SAP HANA Deployment Infrastructure (HDI)?
Please choose the correct answer.

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

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

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

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

Q70. A Node.js module is executed for the first time in SAP HANA extended application services, advanced model (XS advanced). Which of the following activities are performed automatically? There are 2 correct answers to this question.

The source code is compiled to create an executable binary file.

A new SAP HANA Deployment Infrastructure (HDI) container is created.

The required modules are downloaded based on module dependencies.

A new service is executed on the application server.

Q71. 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.

Java Runtime Environment (JRE)

SAP HANA Runtime Tools (HRTT)

SAP Web IDE for SAP HANA

HANA Deployment Infrastructure Container

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

Export the project as an MTA archive.

Activate artifacts via _SYS_REPO.

Store the source in the SAP HANA repository.

Create an MTA project.

Q73. 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.

OSET

ARRAY

UNNEST

UNSET

Q74. Which elements can you specify with the SAP WeblDE for SAP HANA graphical editor for Core Data Services data models? There are 3 correct answers to this question.

Entity

Synonym

Procedure

Context

Association

Q75. You develop a Node.js application for the SAP HANA platform that executes a SQL statement in the SAP HANA database. Which modules do you use?
There are 2 correct answers to this question.

@sap/instance-manager

@sap/xsenv

@sap/hdbext

@sap/node-vsi

Q76. What do you reference in a role template? Please choose the correct answer.

Role Collections

Roles

Routes

Scopes

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

package.json

project.json

server.js

mta.yaml

Q78. Your multi-target application will use XSJS. Which module type do you create in your application project? Please choose the correct answer.

Java

SAP HANA database

Node.js

HTML5

Loading …