C-HCMOD-01 試験問題を無料オンラインアクセス

Why would you use the Transparent Filter property in a calculation view?

• A.To allow filter push-down in stacked calculation views
• B.To avoid columns being unnecessarily used in an aggregation
• C.To include columns that are NOT requested by a query
• D.To apply filters that are hidden from the end user

You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?

• A.Data sources of unions
• B.Filters
• C.Calculated columns
• D.Joins

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes. What is the correct approach?

• A.Combine the transaction tables using an aggregation node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.
• B.Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use a join node to join the DIMENSIONS to the fact table.
• C.Combine the transaction tables using a join node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.
• D.Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use the same star join node to connect the DIMENSIONS to the fact table.

Which of the following data sources can you include in a graphical calculation view? Note: There are 2 correct answers to this question.

• A.Row table
• B.Procedure
• C.Scalar function
• D.Table function

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned. What could be the problem? Note: There are 2 correct answers to this question.

• A.Integrity constraint is set to RIGHT.
• B.The Keep flag is activated for the Customer column.
• C.The Country column is requested.
• D.Join cardinality is set :1.