最新のSAP C-HCMOD-02試験問題解答がズラリ
C-HCMOD-02試験練習テスト問題（更新された82問あります)
SAP C-HCMOD-02 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
質問 33
You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to deploy the calculation view, the deployment fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.
- A. The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.
- B. The imported calculation view and its data source have different namespaces.
- C. An .hdinamespace file is defined in the SRC folder that specifies a different namespace property than the one in the identifier of the calculation view.
- D. The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.
正解: A,B
質問 34
What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.
- A. It is restricted to one DIMENSION in a star join node.
- B. It CANNOT be mixed in the same star join node with other join types.
- C. Only one column can be included in the join condition.
- D. It must appear in the last DIMENSION in the star join node.
正解: A,D
質問 35
Which database features are typically NOT required by analytical applications that run on SAP HANA Cloud?Note: There are 2 correct answers to this question.
- A. Indexes
- B. Table partitions
- C. Pre-calculated aggregates
- D. Stored procedures
正解: A,C
質問 36
In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.
- A. To generate a calculated column
- B. To convert currencies
- C. To generate hierarchies
- D. To define a filter
- E. To generate a restricted column
正解: A,D,E
質問 37
You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it.What do you observe in the SAP HANA database container?
- A. The deployment is successful and the data preview returns expected data.
- B. The deployment fails and the table is dropped.
- C. The deployment fails and the table is not dropped.
- D. The deployment is successful but the data preview returns an error message.
正解: C
質問 38
You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?
- A. Execute the refactor function for the calculation view.
- B. Execute a DROP statement in an SQL Console connected to the HDI container.
- C. Deploy the folder that contained the deleted design-time file.
- D. Deploy the project that contained the deleted design-time file.
正解: D
質問 39
In a database module, what is the purpose of the .hdiconfig file?
- A. To specify in which space the container should be deployed
- B. To specify an external schema in which calculation views will get their data
- C. To specify the namespace rules applicable to the name of database objects
- D. To specify which HDI plug-ins are available
正解: D
質問 40
In SAP HANA Cloud, which tasks are handled by the cloud provider?Note: There are 3 correct answers to this question.Sizing, provisioning, and monitoring the database
- A. Backing up the operating system and the database software
- B. Managing users, roles, and permissions in the database
- C. Installing, configuring, and upgrading the operating system
- D. Tuning the database to run optimally on the underlying operating system, and hardware
正解: A,C,D
質問 41
You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?
- A. Staging area -> Working directory -> Local Git repository
- B. Working directory -> Staging area -> Local Git repository
- C. Local Git repository -> Staging area -> Working directory
- D. Working directory -> Local Git repository -> Staging area
正解: B
質問 42
Using the table in the diagram, you need to create a CUBE calculation view.
What is the simplest approach to create the output shown in the screenshot?
- A. Create a filter expression that uses an OR operator.
- B. Create 3 calculated columns.
- C. Implement a union node and map each country as a separate column.
- D. Create a restricted column for each country.
正解: D
質問 43
You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.
What could be the problem?Note: There are 2 correct answers to this question.
- A. The Country column is requested.
- B. The Keep flag is activated for the Customer column.
- C. Join cardinality is set :1.
- D. Integrity constraint is set to RIGHT.
正解: C,D
質問 44
You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor.
However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?
- A. You already mapped the input parameters in another calculation view.
- B. Your source calculation view is of type DIMENSION.
- C. The names of the input parameters do not match.
- D. You selected the wrong parameter mapping TYPE.
正解: A
質問 45
Which of the following data sources can you include in a graphical calculation view?Note: There are 2 correct answers to this question.
- A. Scalar function
- B. Procedure
- C. Table function
- D. Row table
正解: C,D
質問 46
A calculation view consumes the data sources shown in the graphic.
You want to identify which companies sold products in January AND February. What is the optimal way to do this?
- A. Use an intersect node.
- B. Use a union node.
- C. Use an aggregation node.
- D. Use a minus node
正解: A
質問 47
In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following deploy operations:Deploy the DIMENSION calculation view as a single object.Deploy the entire SAP HANA database module.What is the outcome of the deploy operations?
- A. The first deployment is successful.The second deployment is successful.
- B. The first deployment fails.The second deployment is successful.
- C. The first deployment fails.The second deployment fails.
- D. The first deployment is successful.The second deployment fails.
正解: A
質問 48
Why would you partition a table in an SAP HANA Cloud database? Note: There are 2 correct answers to this question.
- A. To improve response time when multiple users access the same table
- B. To improve data replication performance on large row tables
- C. To overcome the 2 billion record limit
- D. To improve query performance when accessing large column tables
正解: C
質問 49
Why would you enable Debug Query mode in a calculation view?
- A. To understand how tables are partitioned
- B. To set breakpoints and step through the execution
- C. To identify data sources that are not accessed by a query
- D. To check which database engines are invoked
正解: C
質問 50
Why would you create calculation views of data category DIMENSION with type TIME?
- A. To store historical versions of attributes
- B. To provide the time intervals required by time-dependent parent-child hierarchies
- C. To add a temporal condition to a join to find matching records from two tables based on a date
- D. To provide additional time-related navigation possibilities
正解: D
質問 51
At which levels of a project structure can you execute a deploy operation?Note: There are 2 correct answers to this question.
- A. Individual container
- B. Sub-folder of a database module
- C. Individual source file
- D. Entire workspace
正解: B,D
質問 52
What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.
- A. Expected memory consumption
- B. Information about join cardinality
- C. Joins that are defined on calculated columns
- D. Usage statistics of the calculation view
正解: B,C
質問 53
......
あなたを合格させるSAP試験にはC-HCMOD-02試験問題集：https://jp.fast2test.com/C-HCMOD-02-premium-file.html
合格させるC-HCMOD-02試験情報と無料練習テスト：https://drive.google.com/open?id=1o6XbO3x5fuYhkxenhc9Z8YRFAMYghMgO