実際にあるC-HANADEV-18問題集でリアルSAP問題集PDFを提供しています [2024年06月]
実際のJPNTest C-HANADEV-18問題集PDFで100%合格率を保証します
質問 # 54
You created several database tables in a multi-target application and need to keep their names as short as possible. Which parameter of the .hdinamespace file do you set to ignore? Please choose the correct answer.
- A. subfolder
- B. name
- C. mixinTypes
- D. hdbtable
正解：A
解説：
According to the SAP HANA Performance Guide for Developers1, the .hdinamespace file is a JSON resource that defines the naming rules for the run-time objects in a multi-target application. The name parameter specifies the common name-space prefix for the objects, while the subfolder parameter determines whether the name of the sub-folder is added or ignored in the run-time name space. If you want to keep the names of the objects as short as possible, you should set the subfolder parameter to ignore, so that the name of the sub-folder is not appended to the name-space prefix and the object name. For example, if you have a table named CUSTOMERS in a sub-folder named SALES, and you set the subfolder parameter to ignore, the run-time name of the table will be com.sap.hana.example::CUSTOMERS, where com.sap.hana.example is the name-space prefix defined by the name parameter. If you set the subfolder parameter to append, the run-time name of the table will be com.sap.hana.example.SALES::CUSTOMERS, which is longer and more complex. For more information on the .hdinamespace file and the naming rules, see [The HDI Name-Space Configuration File]2 and [Run-Time Name Spaces in SAP HDI]3.
References: 2: The HDI Name-Space Configuration File 3: Run-Time Name Spaces in SAP HDI 1: SAP HANA Performance Guide for Developers
質問 # 55
Which of the following elements can be part of the UI5 application's index.html file? There are 2 correct answers to this question
- A. UI-Area
- B. Framework Reference
- C. Backend Connection
- D. Bootstrap
正解：B、D
解説：
The index.html file is the entry point of the UI5 application. It contains the following elements:
* Framework Reference: This element specifies the location of the UI5 resources, such as libraries, themes, and controls. It can be done by using the data-sap-ui-resourceroots attribute or the sap.ui.localResources() function.
* Bootstrap: This element initializes the UI5 framework and loads the required libraries and components.
It can be done by using the script tag with the src attribute pointing to the sap-ui-core.js file and the data-sap-ui-xx attributes to configure the bootstrap parameters.
* Backend Connection: This element is optional and depends on the application logic. It can be used to establish a connection to the backend system, such as an OData service, by using the data-sap-ui-bindingSyntax attribute or the sap.ui.model.odata.v2.ODataModel() constructor.
* UI-Area: This element defines the HTML element where the UI5 content will be rendered. It can be done by using the data-sap-ui-oninit attribute or the sap.ui.getCore().attachInit() function to register a callback function that creates and places the UI5 root component or view.
References:
* SAP HANA 2.0 SPS06 - Application Development for SAP HANA1, Section 5.1.1, p. 131-132
* SAP HANA 2.0 SPS06 - Developing Web Apps with SAPUI52, Section 2.1, p. 17-20
* SAP HANA 2.0 SPS06 - Developing Web Apps with SAPUI52, Section 3.1, p. 37-40
* SAP HANA 2.0 SPS06 - Developing Web Apps with SAPUI52, Section 4.1, p. 59-62
* SAP HANA 2.0 SPS06 - Developing Web Apps with SAPUI52, Section 5.1, p. 81-84
質問 # 56
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.
- A. Synonyms
- B. Views
- C. Procedures
- D. Imports
正解：A
質問 # 57
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. 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. - B. 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. - C. 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. - D. Create two entities for the user and address.
Create an association in the user entity to the address entity.
正解：D
質問 # 58
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.
- A. Deploy HTML5 modules to the SAP HANA database.
- B. Create objects in the SAP HANA repository.
- C. Configure the artifact namespaces.
- D. Choose the supported SAP HANA versions.
正解：A、C
解説：
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.
質問 # 59
Which activities do you perform on an application in the SAP HANA XS Advanced Cockpit? There are 2 correct answers to this question.
- A. Start, stop, and restart applications.
- B. Monitor applications assigned to the current space.
- C. Display HDI container content.
- D. Deploy applications to SAP Cloud Platform.
正解：A、B
質問 # 60
What are the disadvantages when deploying Dynamic SQL? There are 2 correct answers to this question.
- A. Limited opportunities for optimization
- B. No possibility to use SQL Script variables
- C. No possibility to bind the result to a SQL Script variable
- D. Additional SQL execution privileges are required
正解：A、D
解説：
Dynamic SQL allows you to construct and execute SQL statements at run time, using variables and expressions that may not be supported in SQLScript. However, it also has some drawbacks, such as:
* Limited opportunities for optimization: The SQL statement is potentially recompiled every time it is executed, which may affect the performance and resource consumption. The optimizer cannot use static information, such as data types, cardinalities, or indexes, to generate an optimal execution plan. The statement may also bypass the SQL cache, which stores the results of frequently executed queries for faster retrieval.
* Additional SQL execution privileges are required: The user who executes the dynamic SQL statement must have the necessary privileges to access the objects and operations referenced in the statement. This may pose a security risk, as the user may gain access to sensitive data or perform unauthorized actions.
To prevent SQL injection attacks, the dynamic SQL statement should be validated and sanitized before execution.
The other options are incorrect, because:
* It is possible to bind the result of a dynamic SQL statement to a SQLScript variable, using the INTO clause of the EXECUTE IMMEDIATE statement. For example, EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM "TABLE"' INTO lv_count;
* It is possible to use SQLScript variables in a dynamic SQL statement, using the USING clause of the EXECUTE IMMEDIATE statement. For example, EXECUTE IMMEDIATE 'SELECT * FROM
"TABLE" WHERE "COLUMN" = ?' USING lv_value;
References: SAP HANA Developer Guide, Chapter 6, Section 6.4.2, page 2111.
質問 # 61
Which of the following information must you specify when you create a new project in SAP Web IDE for SAP HANA? There are 2 correct answers to this question.
- A. Project name
- B. SAP HANA database version
- C. Namespace
- D. Template
正解：A、D
解説：
When you create a new project in SAP Web IDE for SAP HANA, you must specify the project name and the template. The project name is a unique identifier for your project that is used to create the folder structure and the deployment descriptor file (mta.yaml) for your project. The template is a predefined set of files and configurations that provide the basic structure and functionality for your project. You can choose from various templates, such as SAP HANA Database Project, SAP Cloud Platform Business Application, SAP Fiori Freestyle Project, and more, depending on your development scenario and requirements.
The following information is not required or not applicable when you create a new project in SAP Web IDE for SAP HANA:
* SAP HANA database version: This information is not required when you create a new project in SAP Web IDE for SAP HANA, as the SAP HANA database version is determined by the target environment where you deploy your project. The SAP Web IDE for SAP HANA supports multiple SAP HANA versions, such as SAP HANA 2.0 SPS 04, SAP HANA 2.0 SPS 05, and SAP HANA Cloud. You can check the compatibility of the SAP Web IDE for SAP HANA and the SAP HANA database versions in the SAP HANA Deployment Infrastructure Reference.
* Namespace: This information is not applicable when you create a new project in SAP Web IDE for SAP HANA, as the namespace is a concept that is used to organize the design-time artifacts in the SAP HANA repository, which is a legacy feature that has been deprecated since SAP HANA 2.0 SPS 02.
Instead of using the SAP HANA repository, you should use the SAP HANA Deployment Infrastructure (HDI) to deploy your database artifacts to HDI containers, which are isolated schemas that represent
* runtime objects. You can configure the artifact namespaces for your HDI containers by editing the
.hdiconfig file in the db module of your project.
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.1: Create a Project, pp. 101-102.
* [SAP HANA Platform Documentation], SAP HANA Developer Guide for SAP HANA XS Advanced Model, Chapter 2: Getting Started with SAP Web IDE for SAP HANA, Section 2.1: Creating a Project, pp. 17-19.
質問 # 62
A user is dropped with the "cascade" option. The user schema also contains objects owned by other users, or on which other users have privileges. What happens to the objects? There are 2 correct answers to this question.
- A. The objects owned by other users are dropped.
- B. The objects on which other users have privileges are dropped.
- C. The objects owned by other users are NOT dropped.
- D. The objects on which other users have privileges are NOT dropped.
正解：A、B
質問 # 63
Your multi-target application will use XSJS. Which module type do you create in your application project?
Please choose the correct answer.
- A. Node.js
- B. Java
- C. HTML5
- D. SAP HANA database
正解：A
解説：
To create a multi-target application that will use XSJS, you need to create a Node.js module type in your application project. XSJS is a scripting language that allows you to implement server-side logic and access SAP HANA database features using JavaScript syntax. XSJS is supported by the Node.js runtime of the SAP HANA XS Advanced Model, which provides the necessary libraries and services to execute XSJS code. You can use the SAP Web IDE for SAP HANA to create a Node.js module and add XSJS files to it. The other options are not correct because:
* A. Java is not the module type you need to create for XSJS, as XSJS is not a Java-based language. Java is a module type that allows you to implement Java applications using the Java runtime of the SAP HANA XS Advanced Model.
* B. SAP HANA database is not the module type you need to create for XSJS, as XSJS is not a database object. SAP HANA database is a module type that allows you to create database artifacts, such as tables, views, procedures, and functions, using the SAP HANA deployment infrastructure (HDI).
* D. HTML5 is not the module type you need to create for XSJS, as XSJS is not a web page. HTML5 is a module type that allows you to create static web content, such as HTML, CSS, and JavaScript files, using the HTML5 application repository service.
References:
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.6
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.7
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.8
* SAP HANA Developer Guide for SAP HANA Web IDE, Chapter 5, Section 5.9
質問 # 64
You configure an OData service for a transactional SAPUI5 application. What is the default data access behavior of the OData service? Please choose the correct answer.
- A. Read: Yes, Create: No Update: Yes Delete: No
- B. Read: Yes Create: Yes Update: Yes Delete: Yes
- C. Read: Yes Create: Yes Update: Yes Delete: No
正解：B
解説：
Read: Yes, Create: No Update: No Delete: No
質問 # 65
In a calculation view, what are the different types of input mapping available in Table Function? There are 2 correct answers to this question.
- A. Data Source Column
- B. Constant
- C. Formula
- D. Variable
正解：A、B
質問 # 66
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.
- A. SVC-based repository
- B. Git-based repository
- C. SAP HANA repository workspace
- D. SAP HANA repository
正解：B
解説：
When you create a multi-target application in SAP Web IDE for SAP HANA, you use a Git-based repository as the source code management option. A Git-based repository allows you to store, manage, and synchronize your code across multiple branches and versions. You can also collaborate with other developers and integrate your changes with the SAP HANA Deployment Infrastructure (HDI). A Git-based repository is the recommended option for developing multi-target applications in SAP Web IDE for SAP HANA. References: Developing Multi-Target Applications, Git Integration, SAP HANA Deployment Infrastructure.
質問 # 67
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.
- A. Java Runtime Environment (JRE)
- B. HANA Deployment Infrastructure Container
- C. SAP HANA Runtime Tools (HRTT)
- D. SAP Web IDE for SAP HANA
正解：B
質問 # 68
A user is dropped with the "cascade" option. The user schema also contains objects owned by other users, or on which other users have privileges. What happens to the objects? There are 2 correct answers to this question.
- A. The objects owned by other users are dropped.
- B. The objects owned by other users are NOT dropped.
- C. The objects on which other users have privileges are dropped.
- D. The objects on which other users have privileges are NOT dropped.
正解：B、D
解説：
When a user is dropped with the "cascade" option, the user and all the objects owned by the user are deleted from the database. However, the objects that are owned by other users, or on which other users have privileges, are not affected by the drop command. The privileges granted to or by the dropped user are also revoked automatically. Therefore, the objects on which other users have privileges are not dropped, and the objects owned by other users are not dropped12.
The other options are not correct because they are not the consequences of dropping a user with the "cascade" option. The objects on which other users have privileges are not dropped, because they are not owned by the dropped user, and they may still be needed by the other users. The objects owned by other users are not dropped, because they are not related to the dropped user, and they may have dependencies or references to other objects. References:
* SAP HANA Platform, SAP HANA SQL and System Views Reference, SQL Reference Manual, SQL Statements, DROP USER
* SAP HANA Platform, SAP HANA Administration Guide, Security, User Management, Dropping Users
質問 # 69
......
検証済みC-HANADEV-18問題集と解答で最新C-HANADEV-18をダウンロード：https://www.jpntest.com/shiken/C-HANADEV-18-mondaishu
無料SAP C-HANADEV-18試験問題と解答があります：https://drive.google.com/open?id=10jG50l-x_non3Y2sHaJM7WMj23rebiv6