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

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.The Keep flag is activated for the Customer column.
• B.Integrity constraint is set to RIGHT.
• C.The Country column is requested.
• D.Join cardinality is set :1.

What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.

• A.Avoid defining joins on calculated columns.
• B.Model star schemas using a sequence of join nodes.
• C.Include all data flow logic within one calculation view.
• D.Aggregate at the lowest possible node.

In Business Application Studio, you rename a DIMENSION calculation view that is used by a CUBE calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following deploy operations:Deploy the DIMENSION calculation view as a single object.Deploy the entire SAP HANA database module.What is the outcome of the deploy operations?

• A.The first deployment is successful.The second deployment is successful.
• B.The first deployment fails.The second deployment is successful.
• C.The first deployment is successful.The second deployment fails.
• D.The first deployment fails.The second deployment fails.

What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

• A.Information about join cardinality
• B.Usage statistics of the calculation view
• C.Joins that are defined on calculated columns
• D.Expected memory consumption

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 a minus node
• B.Use an intersect node.
• C.Use an aggregation node.
• D.Use a union node.