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

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

• A.To improve filter performance in join node
• B.To ignore a filter applied to a hidden column
• C.To prevent filtered columns from producing incorrect aggregation results.
• D.To allow filter push-down in stacked calculation views

You set the Null Handling property for an attribute but do not set a default value. What is displayed when null values are found in a column of data type NVARCHAR?

• A."Null"
• B."2"
• C."#"
• D.<empty string>

In a calculation view, your table function node executes a table function that requires input parameters.
How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.

• A.Reference the output of a procedure.
• B.Map columns from lower nodes.
• C.Assign a hierarchy node.
• D.Define constant values.
• E.Create and map an input parameter.

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

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

Why do you nest flowgraphs? Note: There are 2 correct answers to this question.

• A.To start multiple flowgraphs at the same time
• B.To improve flowgraph performance
• C.To access additional node types
• D.To reduce flowgraph maintenance