C_HCMOD_03 試験問題を無料オンラインアクセス

What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.

• A.Model star schemas using a sequence of join nodes.
• B.Include all data flow logic within one calculation view.
• C.Aggregate at the lowest possible node.
• D.Avoid defining joins on calculated columns.

You are managing your source files using Git. In which sequence does your file progress towards a COMMIT?

• A.Working directory -> Local Git repository -> Staging area
• B.Local Git repository -> Staging area -> Working directory
• C.Working directory -> Staging area -> Local Git repository
• D.Staging area -> Working directory -> Local Git repository

What is generated when you deploy a CUBE calculation view design-time file?Note: There are 2 correct answers to this question.

• A.Cached results to improve read performance
• B.A column view in a container
• C.Metadata to enable consumption by external tools
• D.An SQL execution plan

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.Integrity constraint is set to RIGHT.
• B.Join cardinality is set :1.
• C.The Keep flag is activated for the Customer column.
• D.The Country column is requested.

What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

• A.Results are read from static cache
• B.SQL compilation time increases
• C.Count-distinct results are incorrect
• D.Query processing time improves