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. Define a restricted column in a union node.
B. In the union node, map both source customer name columns to one target column.
C. Include an aggregation node above the union node.
D. Add an intersect node above the union node.
正解:D
質問 2:
Referring to the diagram,
which privileges would a user require to view United States data when querying the CUBE calculation view?
A. SELECT privileges and Analytic Privileges (Country = United States) on both views
B. A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
C. A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
D. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
正解:B
質問 3:
What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.
A. Expected memory consumption
B. Joins that are defined on calculated columns
C. Information about join cardinality
D. Usage statistics of the calculation view
正解:B,C
質問 4:
You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?
A. You did not define at least one input parameter.
B. You did NOT define a valid table type.
C. Your function refers to a scalar function.
D. Your function includes a TRUNCATE statement.
正解:D
質問 5:
Which project structure object corresponds to a unique HDI container?
A. project
B. database module
C. space
D. src folder
正解:D
質問 6:
You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?
A. Local Git repository -> Staging area -> Working directory
B. Working directory -> Local Git repository -> Staging area
C. Staging area -> Working directory -> Local Git repository
D. Working directory -> Staging area -> Local Git repository
正解:D
Nakane -
このC_HCMOD_02参考書と過去問を解けば合格できると思います!