SAP C_HCMOD_01 問題集

質問 1：
You combine two tables in a join node using multiple columns in each table. Why do you enable the dynamic join option? Note: There are 2 correct answers to this question.
A. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query
B. To allow data analysis at different levels of granularity with the same calculation view
C. To ensure that the aggregation always happens after the join execution
D. To ensure that the join execution only uses the join columns requested in the query
正解：B,D

質問 2：
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. The names of the input parameters do not match.
B. You selected the wrong parameter mapping TYPE.
C. You already mapped the input parameters in another calculation view.
D. Your source calculation view is of type DIMENSION.
正解：C

質問 3：
You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name. How do you ensure that each customer name appears only once in the results?
A. Include an aggregation node above the union node.
B. Add an intersect node above the union node.
C. In the union node, map both source customer name columns to one target column.
D. Define a restricted column in a union node.
正解：A

質問 4：
You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL. Which of the following conditions must be met? Note: There are 2 correct answers to this question.
A. The hierarchy must be a parent-child hierarchy.
B. The hierarchy must be a shared hierarchy.
C. The hierarchy must be a local hierarchy.
D. The hierarchy must be exposed by a calculation view of type CUBE with star join.
正解：B,D

質問 5：
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 a DROP statement in an SQL Console connected to the HDI container.
B. Deploy the folder that contained the deleted design-time file.
C. Execute the refactor function for the calculation view.
D. Deploy the project that contained the deleted design-time file.
正解：B

質問 6：
You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes. What is the correct approach?
A. Combine the transaction tables using an aggregation node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.
B. Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use a join node to join the DIMENSIONS to the fact table.
C. Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use the same star join node to connect the DIMENSIONS to the fact table.
D. Combine the transaction tables using a join node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.
正解：D

質問 7：
What is the SQL keyword used to process input parameters defined in a calculation view?
A. SET
B. HINT
C. PLACEHOLDER
D. WHERE
正解：C