Online Access Free C_HCMOD_03 Practice Test

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

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

Why would you use the Transparent Filter property in a calculation view?

• A.To avoid columns being unnecessarily used in an aggregation
• B.To apply filters that are hidden from the end user
• C.To include columns that are NOT requested by a query
• D.To allow filter push-down in stacked calculation views

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

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

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

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

Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note:
There are 2 correct answers to this question.

• A.To avoid exposing sensitive columns when defining calculated columns
• B.To prevent passing columns in stacked calculation views
• C.To ensure specific columns are NOT exposed to the reporting tool
• D.To remove a column that is also used as a Label column