2024年最新の認定サンプル問題C-HANADEV-18問題集と練習試験合格させます
C-HANADEV-18豪華セット学習ガイドにはオンライン試験エンジン
質問 # 22
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?
There are 2 correct answers to this question.
- A. Installation on Mac OS
- B. Installation on Windows Server
- C. Installation on Linux OS
- D. Usage of virtual machine on Microsoft Windows
正解：C、D
質問 # 23
You need to manage an exception in a SQLScript. Which SQLScript features can you use? There are 2 correct answers to this question.
- A. CREATE EXIT HANDLER
- B. SIGNAL
- C. DEFINE RESIGNAL
- D. DECLARE EXIT HANDLER
正解：B、D
質問 # 24
Which metadata declarations can you specify in a SQL Script procedure when you use the SAP HANA Deployment Infrastructure? There are 2 correct answers to this question.
- A. Authorization
- B. Security
- C. Language
- D. Default schema
正解：B、C
質問 # 25
What are the nodes where filter expressions can be used in a calculation view? There are 2 correct answers to this question.
- A. Aggregation
- B. Union
- C. Star join
- D. Rank
正解：A、C
質問 # 26
In an SQL Script procedure, which feature do you use to initialize IN/OUT table parameters? Please choose the correct answer.
- A. IS_EMPTY
- B. DEFAULT
- C. DEFAULT EMPTY
- D. SET
正解：C
質問 # 27
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.
- A. Association
- B. Context
- C. Entity
- D. Procedure
- E. Synonym
正解：A、B、C
解説：
The SAP Web IDE for SAP HANA graphical editor for Core Data Services (CDS) data models allows you to specify the following elements12:
* Entity: An entity is a CDS artifact that defines a data structure with attributes, keys, and associations. An entity can be mapped to a database table or view, or it can be used as a source for another entity or a calculation view. You can create an entity by dragging the entity icon from the palette to the canvas, and then defining its properties and attributes in the properties panel.
* Context: A context is a CDS artifact that defines a namespace for other CDS artifacts, such as entities, views, types, or associations. A context can be used to organize and group related CDS artifacts, and to avoid name conflicts. You can create a context by dragging the context icon from the palette to the canvas, and then defining its name and description in the properties panel. You can also add other CDS artifacts to the context by dragging them from the project explorer or the palette to the context node in the canvas.
* Association: An association is a CDS artifact that defines a relationship between two entities, based on a join condition. An association can be used to navigate from one entity to another, and to filter, aggregate, or project data from the target entity. You can create an association by dragging the association icon from the palette to the canvas, and then connecting it to the source and target entities.
You can also define the cardinality, join condition, and exposed attributes of the association in the properties panel.
The other options are not correct because they are not elements that can be specified with the SAP Web IDE for SAP HANA graphical editor for CDS data models. A synonym is a database object that provides an alternative name for another database object, such as a table, view, or procedure. A synonym is not a CDS artifact, and it cannot be created or edited with the graphical editor. A procedure is a database object that contains a set of SQL statements that perform a specific task. A procedure can be created or edited with the SQL editor, but not with the graphical editor. A procedure can also be exposed as a CDS artifact, but it cannot be specified with the graphical editor. References:
* SAP HANA Platform, SAP HANA Modeling Guide for SAP HANA Web Workbench, Core Data Services
* SAP HANA Platform, SAP HANA Developer Guide for SAP HANA Web IDE, Developing Core Data Services Models, Using the Graphical Editor
質問 # 28
You create a simple data model to store user information. The model contains two tables: one for the user information, and the other for user address details.
The user can only have one address. You also need a view to show the complete information of the user including the address.
Which actions do you perform if you use CDS artifacts only? Please choose the correct answer.
- A. Define a User Details view using select on the user entity and using the association to read the address information.
Create two entities for the user and address.
Extend the user entity with address columns. - B. Create a view named User Details using select on the user entity.
x-s Create two entities for the user and address.
Create a User Details calculation view and join the user and address information. - C. Create two entities for the user and address.
Create an association in the user entity to the address entity.
Define a User Details view using select on the address entity and using the association to read the user information. - D. Create two entities for the user and address.
Create an association in the user entity to the address entity.
正解：A
解説：
The correct action is to define a User Details view using select on the user entity and using the association to read the address information. This way, you can leverage the power of CDS associations to create a join between the user and address entities without explicitly specifying the join condition. You can also use the association path to access the address fields in the view definition. This approach simplifies the data model and avoids redundancy. Option A is incorrect because it selects from the address entity instead of the user entity, which is not the desired output. Option B is incorrect because it extends the user entity with address columns, which is unnecessary and violates the normalization principle. Option D is incorrect because it creates a calculation view instead of a CDS view, which is not the requirement. Calculation views are graphical or scripted views that can be used for complex calculations and data transformations, but they are not CDS artifacts. References:
* SAP HANA 2.0 SPS06 - Application Development for SAP HANA1, Section 2.2.2, p. 32-33
* SAP HANA 2.0 SPS06 - Core Data Services for SAP HANA2, Section 2.3, p. 25-26
* SAP HANA 2.0 SPS06 - Calculation View Modeling3, Section 1.1, p. 7
質問 # 29
What key words are contained in the application descriptor file (xs-app.json)? There are 2 correct answers to this question.
- A. routes
- B. role-templates
- C. authentication Method
- D. tenant-mode
正解：A、C
解説：
The application descriptor file (xs-app.json) is a JSON file that defines the routing and authentication configuration for an HTML5 module in a multi-target application (MTA) project. It is located in the root folder of the HTML5 module and is used by the managed application router to dispatch requests to the appropriate destinations and to authenticate users. Some of the key words that are contained in the xs-app.json file are:
* routes: This is an array of objects that specify the rules for forwarding requests to the back-end microservices or destinations. Each route object has a source property that defines a regular expression to match the request path, and a destination property that defines the name of the destination to which the request should be forwarded. Optionally, a route object can also have other properties, such as authentication, csrfProtection, service, or scope, to further configure the routing behavior.
* authenticationMethod: This is a property that defines the authentication method to be used for the HTML5 module. It can have one of the following values: route, which means that the authentication method is defined by the route configuration; none, which means that no authentication is required; or approuter, which means that the authentication is delegated to the approuter service. The authenticationMethod property can be set at the global level for the entire HTML5 module, or at the route level for a specific route.
The following key words are not contained in the xs-app.json file, but in other files related to the MTA project:
* role-templates: This is an array of objects that define the roles and their corresponding scopes and attributes for the application. The role-templates are defined in the xs-security.json file, which is the application security descriptor file that specifies the security configuration for the application. The xs-security.json file is located in the root folder of the db module and is used by the User Account and Authentication (UAA) service to manage the authorization and trust management for the application.
* tenant-mode: This is a property that defines the tenant mode for the application. It can have one of the following values: dedicated, which means that the application runs in a dedicated schema for each tenant; shared, which means that the application runs in a shared schema for all tenants; or mixed, which means that the application runs in a mixed mode depending on the tenant context. The tenant-mode property is defined in the mta.yaml file, which is the deployment descriptor file that specifies the metadata and dependencies for the MTA project. The mta.yaml file is located in the root folder of the MTA project and is used by the Cloud Foundry environment to deploy the application.
References:
* [SAP HANA Deployment Infrastructure Reference], Chapter 5: HDI with XS Advanced, Section 5.1:
Developing with the SAP Web IDE for SAP HANA, Subsection 5.1.2: Configure Application Routing (xs-app.json), pp. 101-104.
* [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, Subsection 4.1.3: Configure Application Routing (xs-app.json), pp. 77-80.
質問 # 30
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.
- A. Savepoint
- B. Release savepoint
- C. Rollback to savepoint
- D. Reverse savepoint
- E. Alter system savepoint
正解：A、B、C
解説：
According to the SAP HANA SQLScript Reference, the following statements can be used when implementing transaction management logic in SQLScript using savepoints:
* Savepoint: Creates a savepoint with a specified name within the current transaction. A savepoint marks a point in the transaction that can be rolled back to without affecting the rest of the transaction. For example, SAVEPOINT sp1;
* Rollback to savepoint: Rolls back the current transaction to the specified savepoint. All changes made after the savepoint are undone, but the transaction remains active. For example, ROLLBACK TO SAVEPOINT sp1;
* Release savepoint: Releases the specified savepoint and all subsequent savepoints. The released savepoints are no longer valid and cannot be rolled back to. For example, RELEASE SAVEPOINT sp1; The other options are incorrect, because:
* Reverse savepoint is not a valid statement in SQLScript. There is no such statement in the SAP HANA
* SQLScript Reference.
* Alter system savepoint is not a statement that can be used in SQLScript, but a statement that can be used in SQL. It triggers a savepoint operation for the entire database system, not for a specific transaction. It is used for administrative purposes, such as backup and recovery, not for transaction management logic.
References: SAP HANA SQLScript Reference, Chapter 6, Section 6.4.2, page 2111.
質問 # 31
Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer.
- A. Dynamic join
- B. Text join
- C. Multi join
- D. Temporal join
正解：A
質問 # 32
What are the characteristics of SAP HANA calculation views? There are 2 correct answers to this question.
- A. Do NOT need an application server to execute
- B. Do NOT need database tables to execute
- C. Need an application server to execute
- D. Need database tables to execute
正解：A、D
質問 # 33
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.
- A. /Products/'
- B. /Products/$metadata
- C. /Products/ALL
- D. /Products
正解：D
質問 # 34
You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application. What does the mta.xml file contain?
Please choose the correct answer.
- A. The application global elements, modules, resources, properties, and parameters
- B. The plugin name and version for every supported file suffix
- C. The application router description with the authentication methods and access routes
- D. The Node.js package definition with dependencies and initial run configurations
正解：A
解説：
The mta.xml file is the main descriptor file for a multi-target application (MTA). It defines the application global elements, such as ID, version, provider, and schema version. It also defines the modules, which are the components of the application that provide specific functionality, such as a database module, a Node.js module, or an HTML5 module. Each module has a name, a type, a path, and a list of required dependencies.
The mta.xml file also defines the resources, which are the shared services or configurations that the modules can consume, such as a user-provided service, an SAP HANA database, or an SAP HANA HDI container.
Each resource has a name, a type, and optional parameters. The mta.xml file also defines the properties and parameters, which are the key-value pairs that can be used to configure the modules and resources, such as the host, port, or credentials. The properties and parameters can be defined globally, per module, or per resource12.
The other options are not correct because they are not part of the mta.xml file, but rather of other files or components of the MTA. The plugin name and version for every supported file suffix are defined in the .che file, which is the configuration file for the SAP Web IDE3. The application router description with the authentication methods and access routes are defined in the xs-app.json file, which is the configuration file for the application router, a Node.js module that provides a single entry point and routing mechanism for the MTA. The Node.js package definition with dependencies and initial run configurations are defined in the package.json file, which is the configuration file for the Node.js module that contains the application logic and business services. References:
* SAP HANA Platform, Developing Applications with SAP HANA Cloud Platform, Developing Multi-Target Applications
* SAP HANA Platform, SAP HANA Extended Application Services, Advanced Model, Developing and Deploying Applications, Descriptor Files, mta.xml
* SAP HANA Platform, Developing Applications with SAP HANA Cloud Platform, Developing Multi-Target Applications, Descriptor Files, .che
* [SAP HANA Platform], SAP HANA Extended Application Services, Advanced Model, Developing and Deploying Applications, Descriptor Files, xs-app.json
* [SAP HANA Platform], SAP HANA Extended Application Services, Advanced Model, Developing and Deploying Applications, Descriptor Files, package.json
質問 # 35
Which OData service do you use to prevent changes to existing line items of the sap.test :myTable table? Please choose the correct answer.
A)
B)
C)
D)
- A. Option A
- B. Option D
- C. Option B
- D. Option C
正解：D
質問 # 36
Which keywords do you use to define an OData association? There are 3 correct answers to this question.
- A. UNION
- B. DEPENDENT
- C. MULTIPLICITY
- D. JOIN
- E. PRINCIPAL
正解：B、C、E
質問 # 37
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.
- A. On the SAPUI5 HTML5 module
- B. On the SAP Fiori front-end server
- C. On the front-end client device
- D. On the XS advanced application server
正解：C
解説：
The UI rendering is executed on the front-end client device, such as a browser or a mobile device, that accesses the SAP HANA application. SAPUI5 is a JavaScript-based UI framework that enables the development of responsive and user-friendly web applications. SAPUI5 applications run in the browser and communicate with the back-end server via RESTful services, such as OData. The SAPUI5 HTML5 module is a component of the multi-target application (MTA) that contains the UI logic and resources, such as views, controllers, models, and libraries. The SAPUI5 HTML5 module is deployed to the XS advanced application server, which serves the static UI files to the front-end client device. The SAP Fiori front-end server is a separate component that provides the SAP Fiori launchpad, a single entry point for SAP Fiori apps, and the SAP Fiori UI components, such as controls, themes, and icons. The SAP Fiori front-end server is not required for SAP HANA native applications, but it can be used to integrate them with other SAP Fiori apps123.
References:
* SAP HANA Platform, Developing Applications with SAP HANA Cloud Platform, Developing Multi-Target Applications, Developing HTML5 Modules
* SAP HANA Platform, SAP HANA Extended Application Services, Advanced Model, Developing and
* Deploying Applications, Developing HTML5 Applications
* SAP HANA Platform, SAP HANA Extended Application Services, Advanced Model, Developing and Deploying Applications, Developing SAP Fiori Applications
質問 # 38
You need to access a remote database table object within your HDB module in a Multi-target application project.
In SAP HANA extended application services, advanced model (XS advanced) a user-provided service was created to access the external schem a. The service is already declared in the Multi-target application project YAML file.
Which activities do you perform?
- A. Create a view that refers to the table.
- B. Create a view that refers to a synonym. n Create a synonym that refers to the view.
- C. Create/update the .hdbgrants file providing authorizations for the remote schema.
- D. Create a synonym for the remote table object.
- E. There are 3 correct answers to this question.
正解：C、D、E
質問 # 39
What are some of the advantages of SQLScript compared to plain SQL queries? There are 2 correct answers to this question.
- A. It retrieves a high data volume from a database.
- B. It enables modular parameterized programing.
- C. It contains a well-defined ANSI standard.
- D. lt increases performance by parallel execution of complex SQL statements.
正解：B、D
質問 # 40
Which configuration file indicates the program that is executed upon start up when you run the Node.js module? Please choose the correct answer.
- A. project.json
- B. package.json
- C. mta.yaml
- D. server.js
正解：B
解説：
The package.json file is the main configuration file for a Node.js module. It contains various metadata about the module, such as its name, version, dependencies, scripts, and main entry point. The main entry point is the program that is executed when the module is run or required by another module. By default, the main entry point is index.js, but it can be changed by specifying the main property in the package.json file12. For example, if the main property is set to "server.js", then the server.js file will be executed upon start up when the module is run.
The other options are not correct because:
* project.json: This is not a standard configuration file for Node.js modules. It may be used by some frameworks or tools, but it is not recognized by Node.js itself3.
* server.js: This is a common name for a file that contains the server logic for a Node.js module, but it is not a configuration file. It may be the main entry point for the module, but only if it is specified in the package.json file4.
* mta.yaml: This is a configuration file for multi-target applications (MTAs) in SAP HANA XS advanced model. It defines the modules, resources, and dependencies of an MTA, but it is not specific to Node.js modules5.
References: 1: package.json | Node.js v17.0.1 Documentation 2: Debugging in Visual Studio Code 3: How to run Node.js module initialization properly - Stack Overflow 4: Running Node.js Apps with PM2 (Complete Guide) - Better Stack 5: SAP HANA Developer Guide for SAP HANA XS Advanced Model (SAP Web IDE)
質問 # 41
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.
- A. Set a breakpoint in the application.
- B. Open the debugger.
- C. Specify the proper Git repository in the debug properties.
- D. Build the application with the debug option.
- E. Attach the debugger to the node module.
正解：A、B、E
解説：
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
質問 # 42
......
C-HANADEV-18問題集レビュー専門クイズで学習材料：https://www.goshiken.com/SAP/C-HANADEV-18-mondaishu.html
C-HANADEV-18テスト準備トレーニング練習試験問題練習テスト：https://drive.google.com/open?id=1yV4mbJ4BoLLtA1ZTzT0ysUalesOuX6Ie