Online Access Free C_HCMOD_01 Exam Questions

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

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

In a calculation view, what is the purpose of a variable?

• A.To pass values between procedures and calculation views
• B.To break up complex SQL into smaller steps
• C.To provide a dynamic value in a calculated column
• D.To filter an attribute at runtime based on a user input

What can you identify using Performance Analysis mode? Note: There are 2 correct answers to this question.

• A.Joins that are defined on calculated columns
• B.Information about join cardinality
• C.Expected memory consumption
• D.Usage statistics of the calculation view

What are some of the typical roles in an SAP HANA Cloud implementation? Note: There are 2 correct answers to this question.

• A.Data architect
• B.ABAP developer
• C.Kubernetes expert
• D.Modeler

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