What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.
A. Read performance decreases.
B. Aggregates are not adjusted.
C. Memory is not optimized.
D. New records are not read.
正解:A,D
質問 2:
Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.
A. Julian
B. Factory
C. Fiscal
D. Gregorian
正解:C,D
質問 3:
What can you do with shared hierarchies? Note:There are 2 correct answers to this question.
A. Access hierarchies created in external schemas
B. Provide reusable hierarchies for drilldown in a CUBE without star join
C. Enable SQL SELECT statements to access hierarchies
D. Provide reusable hierarchies for drilldown in a CUBE with star join
正解:B,C
質問 4:
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 a local hierarchy.
C. The hierarchy must be exposed by a calculation view of type CUBE with star join.
D. The hierarchy must be a parent-child hierarchy.
正解:A,C
質問 5:
What is the default view node for a cube?
A. SEMANTICS
B. PROJECTION
C. AGGREGATION
D. UNION
正解:C
質問 6:
Why would you enable Debug Query mode in a calculation view?
A. To set breakpoints and step through the execution
B. To check which database engines are invoked
C. To identify data sources that are not accessed by a query
D. To understand how tables are partitioned
正解:C
質問 7:
Which of the following techniques can you use to improve the performance of calculation views?Note: There are 2 correct answers to this question.
A. Avoid aggregating data early in the data flow.
B. Partition large tables.
C. Implement union pruning.
D. Limit the number of stacked calculation views.
正解:B,D
質問 8:
You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?
A. Define a restricted column in a union node.
B. In the union node, map both source customer name columns to one target column.
C. Include an aggregation node above the union node.
D. Add an intersect node above the union node.
正解:C
質問 9:
When is the first column store compression executed?
A. When partitions are regenerated
B. When a backup is started
C. When the table is created
D. When a delta merge is triggered
E. Question
正解:D
Fujikuro -
出題頻度の高いテーマを中心に、解説+過去問題で構成したC_HCMOD_05参考書って感じだね。Pass4Testさんオカゲさまで合格です。