Why would you use the Transparent Filter property in a calculation view?
A. To allow filter push-down in stacked calculation views
B. To ignore a filter applied to a hidden column
C. To improve filter performance in join node
D. To prevent filtered columns from producing incorrect aggregation results.
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
When you build/deploy a flowgraph, what can be generated? Note: There are 3 correct answers to this question.
A. Replication Task
B. Procedure
C. Function
D. Batch Task
E. Real-time Task
正解:B,D,E
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
You have configured static cache for your calculation view and run a query against it, but the cache results are not being used. What might be the reason for this?
A. You did not define a filter in the cache setting.
B. The query requests only a subset of the cached results.
C. The cache data retention period has expired.
D. Your cache setting does not specify any columns.
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
What is the default top view node for a calculation view of type CUBE?
A. PROJECTION
B. HIERARCHY
C. AGGREGATION
D. UNION
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
Which type of join supports a temporal condition in a calculation view?
A. Inner join
B. Referential join
C. Text join
D. Left outer join
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
You have generated a calculation view properties file. What does it contain?
A. All settings defined in a calculation view
B. Documentation to support the calculation view
C. Descriptions of all objects defined in a calculation view
D. Dependencies between calculation views
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL. Which of the following conditions must be met? Note: There are 2 correct answers to this question.
A. The hierarchy must be a shared hierarchy.
B. The hierarchy must be defined as a local hierarchy.
C. The hierarchy must be exposed by a CUBE calculation view with star join.
D. The hierarchy must be a parent-child hierarchy.
正解:A,C
質問 8:
You want to join two tables in a calculation view. Why do you use a non-equi join?
A. The number of joined columns is different in each table.
B. The join condition is not represented by matching values.
C. Join columns need to be ignored when NOT requested by the query.
D. Join columns have different data types.
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
Tanaka -
まじめにやれば受かると思う。過去問を解くことを繰り返していれば問題なくC_HAMOD_2404合格できると感じました。