Free SAP C-HCMOD-03 Exam Dumps Questions & Answers

Why would you create calculation views of data category DIMENSION with type TIME?

• A.  To store historical versions of attributes
• B.  To provide the time intervals required by time-dependent parent-child hierarchies
• C.  To provide additional time-related navigation possibilities
• D.  To add a temporal condition to a join to find matching records from two tables based on a date

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.  A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
• D.  SELECT privileges and Analytic Privileges (Country = United States) on both views

In a database module, what is the purpose of the .hdiconfig file?

• A.  To specify an external schema in which calculation views will get their data
• B.  To specify the namespace rules applicable to the name of database objects
• C.  To specify which HDI plug-ins are available
• D.  To specify in which space the container should be deployed

You combine two tables in a join node using multiple columns in each table.Why do you enable the dynamic join option? Note: There are 2 correct answers to this question.

• A.  To allow data analysis at different levels of granularity with the same calculation view
• B.  To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query
• C.  To ensure that the join execution only uses the join columns requested in the query
• D.  To ensure that the aggregation always happens after the join execution

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.  Multiple blocks can only be defined within a single calculation view.
• B.  The block must start with a node that defines a table as a data source.
• C.  The block must only have one start node.
• D.  Only one block can be defined across a stack of calculation views.