Microsoft
70-463 · Question #133
70-463 Question #133: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #133. The question stem and answer options stay visible for context.
Design and implement a data warehouse
Question
You are designing a partitioning strategy for a large fact table in a data warehouse. Tens of millions of new records are loaded into the data warehouse weekly, outside of business hours. Most queries are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level. You need to partition the table to maximize the performance of queries. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- APartition the fact table by month, and compress each partition.
- BPartition the fact table by week.
- CPartition the fact table by year.
- DPartition the fact table by day, and compress each partition.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#table partitioning#partition compression#query optimization#data warehouse performance