Online Access Free C_HCMOD_01 Exam Questions

Which calendar types can be selected when creating time-based DIMENSIONS? Note: There are 2 correct answers to this question.

• A.Factory
• B.Fiscal
• C.Julian
• D.Gregorian

Which of the following data sources can you include in a graphical calculation view? Note: There are 2 correct answers to this question.

• A.Row table
• B.Procedure
• C.Table function
• D.Scalar function

You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to deploy it. What do you observe in the SAP HANA database container?

• A.The deployment fails and the table is dropped.
• B.The deployment is successful and the data preview returns expected data.
• C.The deployment is successful but the data preview returns an error message.
• D.The deployment fails and the table is not dropped.

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.Create and map an input parameter.
• B.Map columns from lower nodes.
• C.Define constant values.
• D.Assign a hierarchy node.
• E.Reference the output of a procedure.

What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

• A.Break up large statements by using variables.
• B.Use dynamic SQL.
• C.Choose declarative language instead of imperative language.
• D.Control the flow logic using IF-THEN-ELSE conditions.