Online Access Free C_HCMOD_02 Exam Questions

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 a restricted column for each country.
• B.Create 3 calculated columns.
• C.Implement a union node and map each country as a separate column.
• D.Create a filter expression that uses an OR operator.

A calculation view consumes the data sources shown in the graphic.

You want to identify which companies sold products in January AND February. What is the optimal way to do this?

• A.Use a minus node
• B.Use an aggregation node.
• C.Use an intersect node.
• D.Use a union node.

Why would you use the Transparent Filter property in a calculation view?

• A.To apply filters that are hidden from the end user
• B.To avoid columns being unnecessarily used in an aggregation
• C.To include columns that are NOT requested by a query
• D.To allow filter push-down in stacked calculation views

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

You create a user-provided service to access tables in external schemas.In which file type do you assign the user-provided service to your database module?

• A..namespace
• B..hdiconfig
• C..yaml
• D..mtar