C_HCMOD_03 exam

In a database module, what is the purpose of the .hdiconfig file?A . To specify an external schema in which calculation views will get their data B. To specify which HDI plug-ins are available C. To specify in which space the container should be deployed D. To specify the namespace...

You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?A . Calculated columns B. Filters C. Joins D. Data sources of unionsView AnswerAnswer: B

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 . Define constant values. B. Assign a hierarchy node. C. Reference the output of...

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

Why would you create calculation views of data category DIMENSION with type TIME?A . To provide additional time-related navigation possibilities B. To add a temporal condition to a join to find matching records from two tables based on a date C. To store historical versions of attributes D. To provide...

What are the limitations of using a full outer join in a star join node? Note: There are 2 correct answers to this question.A . It must appear in the last DIMENSION in the star join node. B. It is restricted to one DIMENSION in a star join node. C....

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 calendar types can be selected when creating time-based DIMENSIONS? Note: There are 2 correct answers to this question.A . Fiscal B. Julian C. Gregorian D. FactoryView AnswerAnswer: A,C

Which tool generates and executes the SQL for a specific node of your calculation view?A . Debug Query mode B. Explain plan C. SQL analyzer D. Database explorerView AnswerAnswer: A

Why would you enable Debug Query mode in a calculation view?A . To identify data sources that are not accessed by a query B. To check which database engines are invoked C. To set breakpoints and step through the execution D. To understand how tables are partitionedView AnswerAnswer: A