[2024年01月] 検証済み SAP C_HANADEV_18 リアル豪華お試しセット試験問題集 PDF [Q36-Q54]

4/5 - (1 vote)

[2024年01月] 検証済みSAP C_HANADEV_18リアル豪華お試しセット試験問題集でPDF

C_HANADEV_18問題集PDF最新 [2024年最新] 究極の学習ガイド

試験は、データモデリング、SQLスクリプト、およびアプリケーション開発に関連するSAP HANA開発に関するトピックの範囲をカバーしています。成功した候補者は、SAP HANAアーキテクチャについての確固たる理解力だけでなく、プラットフォーム上で効果的なデータモデルやアプリケーションを設計・実装できる能力も必要とされます。

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

It enables modular parameterized programing.

lt increases performance by parallel execution of complex SQL statements.

It contains a well-defined ANSI standard.

It retrieves a high data volume from a database.

質問 37
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

質問 38
Which keywords do you use to define an OData association? There are 3 correct answers to this question.

JOIN

DEPENDENT

UNION

MULTIPLICITY

PRINCIPAL

質問 39
In a calculation view, what are the different types of input mapping available in Table Function? There are 2 correct answers to this question.

Variable

Constant

Formula

Data Source Column

質問 40
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

質問 41
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

質問 42
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

質問 43
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

質問 44
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.

The SAP Web IDE for SAP HANA is a web-based development tool that allows you to create and manage multi-target applications (MTAs) that use the SAP HANA Deployment Infrastructure (HDI). HDI is a service layer that enables you to deploy database development artifacts to HDI containers, which are isolated schemas that represent runtime objects. Some of the operations that you can perform in the SAP Web IDE for SAP HANA are:
* Deploy HTML5 modules to the SAP HANA database: HTML5 modules are web applications that run on the XS advanced runtime and can access HDI containers via service bindings. You can create, edit,
* test, and deploy HTML5 modules from the SAP Web IDE for SAP HANA using the MTA development perspective and the build and run commands. You can also use the HTML5 module template wizard to generate a basic HTML5 module with the required configuration files and dependencies.
* Configure the artifact namespaces: Artifact namespaces are prefixes that are added to the names of the database artifacts that are deployed to the HDI containers. They help to avoid name conflicts and to organize the artifacts in a logical way. You can configure the artifact namespaces in the SAP Web IDE for SAP HANA by editing the .hdiconfig file in the db module of your MTA project. You can also use the namespace template wizard to generate a .hdiconfig file with a default namespace.
The following operations are not possible or not recommended in the SAP Web IDE for SAP HANA:
* Create objects in the SAP HANA repository: The SAP HANA repository is a legacy feature that was used to store and manage design-time artifacts in SAP HANA 1.0. It has been deprecated since SAP HANA 2.0 SPS 02 and replaced by HDI. Therefore, you should not create objects in the SAP HANA repository, but rather use HDI containers and the SAP Web IDE for SAP HANA to develop and deploy database artifacts.
* Choose the supported SAP HANA versions: The SAP Web IDE for SAP HANA does not allow you to choose the supported SAP HANA versions for your MTA project. The supported SAP HANA versions depend on the HDI version and the SAP HANA Cloud Platform, which are determined by the target environment where you deploy your MTA project. You can check the compatibility of the HDI version and the SAP HANA Cloud Platform in the SAP HANA Deployment Infrastructure Reference.
References:
* [SAP HANA Deployment Infrastructure Reference], Chapter 5: HDI with XS Advanced, Section 5.1:
Developing with the SAP Web IDE for SAP HANA, pp. 101-106.
* [SAP HANA Platform Documentation], SAP HANA Developer Guide for SAP HANA XS Advanced Model, Chapter 4: Developing HTML5 Applications, Section 4.1: Developing HTML5 Applications Using SAP Web IDE for SAP HANA, pp. 77-82.

質問 45
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.

To create a native SAP HANA application that fully leverages the SAP HANA platform, you should implement data-intensive calculations on the database layer, using SQLScript or calculation views. SQLScript is a scripting language that allows you to write stored procedures, functions, and triggers that perform complex calculations and data transformations on the SAP HANA database. Calculation views are graphical or scripted views that define data models based on tables, views, or other calculation views, and apply filters, joins, aggregations, and other operations on the data. By pushing the calculations onto the database layer, you can take advantage of the in-memory processing, parallelization, and optimization capabilities of SAP HANA, and reduce the data transfer and network latency between the application layer and the database layer123.
The other options are not correct because they do not fully leverage the SAP HANA platform, and they may result in poor performance, high resource consumption, and increased complexity. Pushing the calculations onto the application layer means that you use a programming language, such as Java or Node.js, to perform the calculations on the application server, which may not be as efficient or scalable as the database server. Pushing the calculations onto the presentation layer means that you use a UI framework, such as SAPUI5 or SAP Fiori, to perform the calculations on the client device, such as a browser or a mobile device, which may not have enough processing power or memory to handle large or complex data sets. Distributing the calculations between the application layer and the presentation layer means that you split the calculations into different parts and execute them on different layers, which may introduce inconsistency, redundancy, and dependency issues. References:
* SAP HANA Platform, SAP HANA SQL and System Views Reference, SQLScript Guide
* SAP HANA Platform, SAP HANA Modeling Guide for SAP HANA Web Workbench, Calculation Views
* SAP HANA Platform, Developing Applications with SAP HANA Cloud Platform, Developing Multi-Target Applications, Developing Database Modules

質問 46
Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question.

SCHEMAS

TABLES

OBJECTS

ROLES

質問 47
Which SAP HANA extended application services, advanced model (XS advanced) tools can you use to retrieve the URL for the SAP WeblDE for SAP HANA?
There are 2 correct answers to this question.

Runtime tool

XS advanced Controller Start Screen

XS Advanced command-line client tool

Organization and Space Management tool

質問 48
In Node.js, which file do you use to define external module dependencies? Please choose the correct answer.

mta.yaml

pom.xml

package.json

server.js

質問 49
Which OData service do you use to prevent changes to existing line items of the sap.test :myTable table?
Please choose the correct answer.

質問 50
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

質問 51
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.

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

Object

Role

Privilege

User

質問 53
Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question.

SCHEMAS

TABLES

OBJECTS

ROLES

質問 54
What are the steps to debug a Node.js application using SAP Web IDE for SAP HANA? There are 3 correct answers to this question.

Attach the debugger to the node module.

Set a breakpoint in the application.

Specify the proper Git repository in the debug properties.

Build the application with the debug option.

Open the debugger.

To debug a Node.js application using SAP Web IDE for SAP HANA, you need to perform the following steps:
* Open the debugger. You can open the debugger from the toolbar by clicking the \uE921 (debugger) icon, or from the menu by choosing Tools Debugger . The debugger opens in a new browser tab and shows a list of all Node.js modules in your project, as well as the available debug configurations.
* Attach the debugger to the node module. You can attach the debugger to any running Node.js module in your project by selecting the module name and clicking the \uE921 (attach) icon. Alternatively, you can create a new debug configuration for the module by clicking the \uE921 (create) icon and specifying the module name, the port number, and the source mapping. The debugger will connect to the Node.js module and switch it to debug mode.
* Set a breakpoint in the application. You can set a breakpoint in the application code by opening the file in the editor and clicking the left margin next to the line number where you want to pause the execution.
A red dot will appear to indicate the breakpoint. You can also use the \uE921 (breakpoints) pane to view, enable, disable, or remove breakpoints.
* Run the application. You can run the application from the browser by clicking the application URL in the run console, or from the command line by using the cf CLI commands. The application will execute until it reaches a breakpoint or an exception, and then pause and show the current state of the variables, call stack, and watch expressions in the debugger.
* Debug the application. You can use the debugger to inspect and modify the variables, evaluate expressions, step over, step into, step out, or resume the execution, as well as view the console output and the server log. You can also detach the debugger from the module by clicking the \uE921 (detach) icon, or stop the module by clicking the \uE921 (stop) icon.
The other option is incorrect because you do not need to specify the proper Git repository in the debug properties. The Git repository is used to manage the source code of the application, but it is not relevant for the debugging process. You also do not need to build the application with the debug option, because the debugger can attach to any running Node.js module without any special build settings. References:
* Running and Testing Node.js Modules – SAP Help Portal
* Debugging Node.js Modules – SAP Help Portal