Online Access Free C-HCMOD-05 Exam Questions

Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

• A.Fiscal
• B.Julian
• C.Factory
• D.Gregorian

What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

• A.Choose declarative language instead of imperative language.
• B.Use dynamic SQL.
• C.Control the flow logic using IF-THEN-ELSE conditions.
• D.Break up large statements by using variables.

What is the SQL keyword used to process input parameters defined in a calculation view?

• A.HINT
• B.WHERE
• C.PLACEHOLDER
• D.SET

What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

• A.Information about join cardinality
• B.Usage statistics of the calculation view
• C.Expected memory consumption
• D.Joins that are defined on calculated columns

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 Country column is requested.
• D.The Keep flag is activated for the Customer column.