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

A calculation view consumes the data sources shown in the graphic. You want to identify which companies sold products in January AND February. What is the optimal way to do this?

• A.Use an intersect node.
• B.Use an aggregation node.
• C.Use a union node.
• D.Use a minus node.

Which of the following approaches might improve the performance of joins in a CUBE calculation view?
Note: There are 2 correct answers to this question.

• A.Specify the join cardinality.
• B.Limit the number of joined columns.
• C.Use an inner join.
• D.Define join direction in a full outer join.

What is the default top view node for a calculation view of type CUBE?

• A.AGGREGATION
• B.PROJECTION
• C.UNION
• D.HIERARCHY

You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources.
How do you check if pruning occurs? Note: There are 2 correct answers to this question.

• A.Check the SQL query generated by the Data Preview.
• B.Use the SQL Analyzer to identify the tables used.
• C.Observe which columns are mapped using the Performance Analysis mode.
• D.Enable the Debug Query mode to identify the source columns used.

What is the purpose of a remote subscription?

• A.To establish a connection to the replication service
• B.To assign a virtual table to a remote source
• C.To be notified when remote data has changed
• D.To update data in a local table based on changes made to a remote table