Online Access Free C-HCMOD-03 Practice Test

Referring to the diagram,

which privileges would a user require to view United States data when querying the CUBE calculation view?

• A.A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
• B.A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
• C.SELECT privileges and Analytic Privileges (Country = United States) on both views
• D.A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view

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

What can you do with shared hierarchies? Note:There are 2 correct answers to this question.

• A.Enable SQL SELECT statements to access hierarchies
• B.Provide reusable hierarchies for drilldown in a CUBE without star join
• C.Provide reusable hierarchies for drilldown in a CUBE with star join
• D.Access hierarchies created in external schemas

At which levels of a project structure can you execute a deploy operation?Note: There are 2 correct answers to this question.

• A.Entire workspace
• B.Sub-folder of a database module
• C.Individual container
• D.Individual source file

In a calculation view, why would you choose the DEPRECATED setting?Note: There are 2 correct answers to this question.

• A.To lock the calculation view from further modifications
• B.To ensure it is not exposed to reporting tools for consumption
• C.To warn developers that the calculation view is no longer supported
• D.To indicate that it should not be used as a data source to other calculation views