C_HCMOD_02 exam

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 . Set the HIDE property for columns NOT required.B . Write and execute a custom SQL query...

You combine two tables in a join node using multiple columns in each table. Why do you enable the dynamic join option? Note: There are 2 correct answers to this question.A . To ensure that the join execution only uses the join columns requested in the queryB . To ensure...

Why would you use the SQL analyzer? Note: There are 2 correct answers to this question.A . To warn of potential performance issues related to calculated columnsB . To display the execution time of a calculation viewC . To identify the root data sources of a functionD . To preview...

Why would you set the "Ignore multiple outputs for filters" property in a calculation view?A . To ensure semantic correctnessB . To hide columns that are not requiredC . To avoid duplicate rows in the outputD . To force filters to apply at the lowest nodeView AnswerAnswer: D

You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?A . Calculated columnsB . FiltersC . JoinsD . Data sources of unionsView AnswerAnswer: B

What is a restricted measure?A . A measure that can be consumed by a CUBE and not a DIMENSIOC . A measure that is filtered by one or more attribute values.D . A measure that can only be displayed by those with necessary privileges.E . A measure that cannot be...

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...

Why would you use parameter mapping in a calculation view? Note: There are 2 correct answers to this question.A . To pass variable values to external value help viewsB . To assign variables to one or more attributesC . To push down filters to the lowest level calculation viewsD ....

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 . Partition large tables.C . Limit the number of stacked calculation views.D . Implement union pruning.View AnswerAnswer:...

Which tool generates and executes the SQL for a specific node of your calculation view?A . Debug Query modeB . Explain planC . SQL analyzerD . Database explorerView AnswerAnswer: A