What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question.
A. Improved write performance on frequent updates
B. Parallel access is improved
C. Higher data compression rates
D. Higher performance for query operations
E. Additional indexes are used
正解:B,C,D
質問 2:
What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.
A. Control the flow logic using IF-THEN-ELSE conditions.
B. Use dynamic SQL.
C. Choose declarative language instead of imperative language.
D. Break up large statements by using variables.
正解:C,D
質問 3:
What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.
A. Include all data flow logic within one calculation view.
B. Avoid defining joins on calculated columns.
C. Aggregate at the lowest possible node.
D. Model star schemas using a sequence of join nodes.
正解:A,B
質問 4:
You have defined a pruning configuration table in a calculation view.What are you attempting to prune from the query execution?
A. Joins
B. Calculated columns
C. Filters
D. Data sources of unions
正解:C
質問 5:
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
985 お客様のコメント





赤*唯 -
合格しました!かなりのC_HCMOD_02的中率でした。Pass4Testありがとうございました。