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.)
A.
Partition the fact table by month, and compress each partition.
B.
Partition the fact table by week.
C.
Partition the fact table by year.
D.
Partition the fact table by day, and compress each partition.
Explanation: