Free SAP C_HCMOD_05 Exam Dumps Questions & Answers

What options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.

• A.  Define an expression to determine a parent.
• B.  Generate additional root nodes.
• C.  Assign them to a node at the root level.
• D.  Assign them to a level below the root.

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

• A.  You did NOT define a valid table type.
• B.  Your function refers to a scalar function.
• C.  You did not define at least one input parameter.
• D.  Your function includes a TRUNCATE statement.

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

• A.  Access hierarchies created in external schemas
• 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.  Enable SQL SELECT statements to access hierarchies

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

Why would you create SQL in calculation views?

• A.  To enable write capabilities
• B.  To provide an alternative to graphical modeling
• C.  To fine-tune performance
• D.  To implement custom logic