Online Access Free C-HCMOD-02 Practice Test

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

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

You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns.What is the recommended approach for verifying the results?

• A.Write and execute a custom SQL query in the SQL Console.
• B.Set the HIDE property for columns NOT required.
• C.Select and deselect columns from the output mapping.
• D.Select Data Preview for the calculation view.

Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.

• A.Avoid aggregating data early in the data flow.
• B.Limit the number of stacked calculation views.
• C.Partition large tables.
• D.Implement union pruning.

In a calculation view, your table function node executes a table function that requires input parameters. How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.

• A.Assign a hierarchy node.
• B.Create and map an input parameter
• C.Define constant values.
• D.Reference the output of a procedure.
• E.Map columns from lower nodes.

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

• A.To convert currencies
• B.To define a filter
• C.To generate a calculated column
• D.To generate a restricted column
• E.To generate hierarchies