Free SAP C-HANADEV-18 Exam Questions & Answer from Training Expert ExamBoosts [Q29-Q52]

ExamBoosts October 16, 2023 C-HANADEV-18 > SAP 0

Rate this post

Free SAP C-HANADEV-18 Exam Questions and Answer from Training Expert ExamBoosts

Top SAP C-HANADEV-18 Courses Online

NEW QUESTION 29
You work on a multi-target application that uses the SAP HANA Deployment Infrastructure (HDI). Which operations can you perform in the SAP Web IDE for SAP HANA?
There are 2 correct answers to this question.

Create objects in the SAP HANA repository.

Deploy HTML5 modules to the SAP HANA database.

Choose the supported SAP HANA versions.

Configure the artifact namespaces.

NEW QUESTION 30
Which of the following are characteristics of database procedures?

Database procedures can have both input and output parameters; however, a parameter CANNOT be both input and output.

Database procedures can have several output parameters, and a mix of both scalar and table types is possible.

If, in the database procedure header, you use the READS SQL DATA option, then INSERT statements are prohibited; however, dynamic SQL is allowed.

If, in the database procedure header, you use the SQL SECURITY INVOKER option, then only the owner of the procedure can start it.

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

Outer Join

Text Join

Referential Join

Inner Join

NEW QUESTION 32
Which OData capacities are supported in SAP HANA extended application services, advanced model (XSA)? There are 3 correct answers to this question.

Union

Aggregation

Join

Projection

Association

NEW QUESTION 33
Which Node.js module do you use to run an SQL statement against the SAP HANA database? Please choose the correct answer.

@sap/hdi

@sap/xsenv

@sap/xssec

@sap/hdbext

NEW QUESTION 34
You need to combine data from different database tables within your OData service. Which capability do you use for this relationship? Please choose the correct answer.

Aggregations

Projections

Associations

Entity sets

NEW QUESTION 35
Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer.

Dynamic join

Text join

Temporal join

Multi join

NEW QUESTION 36
What are the characteristics of SAP HANA calculation views? There are 2 correct answers to this question.

Need an application server to execute

Need database tables to execute

Do NOT need database tables to execute

Do NOT need an application server to execute

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

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

NEW QUESTION 39
You create a multi-target application in SAP Web IDE for SAP HANA. Which source code management option do you use? Please choose the correct answer.

SVC-based repository

Git-based repository

SAP HANA repository workspace

SAP HANA repository

NEW QUESTION 40
What are the different types of graphical calculation views that can handle measures? There are 2 correct answers to this question.

Cube

Dimension

SQL Access Only

Cube with star join

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

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

NEW QUESTION 43
You need to manage an exception in a SQLScript. Which SQLScript features can you use? There are 2 correct answers to this question.

DECLARE EXIT HANDLER

SIGNAL

DEFINE RESIGNAL

CREATE EXIT HANDLER

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

NEW QUESTION 45
You implement a native SAP HANA application using SAP HANA extended application services, advanced model (XS advanced) and SAPUI5. Where is the UI rendering executed? Please choose the correct answer.

On the SAPUI5 HTML5 module

On the SAP Fiori front-end server

On the front-end client device

On the XS advanced application server

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

It supports the full set of SQL Script.

It defines how data is processed.

It is free of side effects.

lt declares the flow of data.

NEW QUESTION 47
In application development with XS advanced, which of the following entities belong to a specific SPACE? There are 2 correct answers to this question.

Organizations

Users

Applications

Processes

NEW QUESTION 48
Which artifacts do you define in the persistence model to access objects in an external SAP HANA Deployment Infrastructure container? Please choose the correct answer.

Views

Synonyms

Imports

Procedures

NEW QUESTION 49
You are asked to produce sales value for the month using sales order line items (sales price per item x quantity sold) what do you use to achieve this in a calculated column of a calculation view? There are 2 correct answers to this question.

Keep flag

Dynamic join

Transparent filter

Non-equijoin

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

It is passed using a WHERE clause.

It can NOT be used to filter measure values.

It can be used in a conditional expression.

It is passed via reserved word PLACEHOLDER.

It can be used to pass values to table functions.

NEW QUESTION 51
Which OData capacity do you use when you need to restrict the number or selection of exposed columns? Please choose the correct answer.

Parameter entity sets

Aggregation

Key specification

Property projection

NEW QUESTION 52
Which functionality is provided by SAP WeblDE for SAP HANA? There are 2 correct answers to this question.

Syntax-aware editors for code

User management

Build and deploy applications

Organization and space management

Loading …