Online Access Free C_HCMOD_03 Exam Questions

What is a restricted measure?

• A.A measure that cannot be referenced by a calculated column.
• B.A measure that can be consumed by a CUBE and not a DIMENSION.
• C.A measure that can only be displayed by those with necessary privileges.
• D.A measure that is filtered by one or more attribute values.

Using the table in the diagram, you need to create a CUBE calculation view.
What is the simplest approach to create the output shown in the screenshot?

• A.Create 3 calculated columns.
• B.Implement a union node and map each country as a separate column.
• C.Create a filter expression that uses an OR operator.
• D.Create a restricted column for each country.

You deleted the design-time file of a calculation view in your HDB module.What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

• A.Execute the refactor function for the calculation view.
• B.Execute a DROP statement in an SQL Console connected to the HDI container.
• C.Deploy the folder that contained the deleted design-time file.
• D.Deploy the project that contained the deleted design-time file.

What are some of the restrictions that apply when defining parallelization blocks in calculation views?
Note: There are 2 correct answers to this question.

• A.The block must start with a node that defines a table as a data source.
• B.The block must only have one start node.
• C.Multiple blocks can only be defined within a single calculation view.
• D.Only one block can be defined across a stack of calculation views.

Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

• A.To push down filters to the lowest level calculation views
• B.To assign variables to one or more attributes
• C.To convert the data types of input parameters
• D.To pass variable values to external value help views