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

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

Why would you create calculation views of data category DIMENSION with type TIME?

• A.To add a temporal condition to a join to find matching records from two tables based on a date
• B.To provide additional time-related navigation possibilities
• C.To provide the time intervals required by time-dependent parent-child hierarchies
• D.To store historical versions of attributes

Why do you use the Hidden Columns checkbox in the semantics node of your calculation view? Note:
There are 2 correct answers to this question.

• A.To avoid exposing sensitive columns when defining calculated columns
• B.To remove a column that is also used as a Label column
• C.To prevent passing columns in stacked calculation views
• D.To ensure specific columns are NOT exposed to the reporting tool

You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud. Why should you switch calculated column expression language from column engine to SQL?

• A.Column engine language is not supported.
• B.To define limits for query unfolding
• C.To benefit from additional SQL optimizations
• D.Incorrect aggregations may be generated

A calculation view includes a rank node that uses the source data and settings shown in the graphic.
Your query requests all columns of the rank node. How many rows are in the output of your query?

• A.6
• B.2
• C.9
• D.5