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

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?

• A.Include an aggregation node above the union node.
• B.Add an intersect node above the union node.
• C.In the union node, map both source customer name columns to one target column.
• D.Define a restricted column in a union node.

Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

• A.To hide columns that are not required
• B.To ensure semantic correctness
• C.To force filters to apply at the lowest node
• D.To avoid duplicate rows in the output

Why would you enable Debug Query mode in a calculation view?

• A.To identify data sources that are not accessed by a query
• B.To set breakpoints and step through the execution
• C.To understand how tables are partitioned
• D.To check which database engines are invoked

You want to join two tables in a calculation view.Why do you use a non-equi join?

• A.The join condition is not represented by matching values.
• B.Join columns have different data types.
• C.Join columns need to be ignored when NOT requested by the query.
• D.The number of joined columns is different in each table.

Why would you create SQL in calculation views?

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