C_HCMOD_01 試験問題を無料オンラインアクセス

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 at least one input parameter.
• B.You did NOT define a valid table type.
• C.Your function includes a TRUNCATE statement.
• D.Your function refers to a scalar function.

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 avoid columns being unnecessarily used in an aggregation
• D.To allow filter push-down in stacked calculation views

Why would you use the SQL analyzer? Note: There are 2 correct answers to this question.

• A.To warn of potential performance issues related to calculated columns
• B.To identify the root data sources of a function
• C.To preview data at the node level of a calculation view
• D.To display the execution time of a calculation view

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

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

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