You need to partition the table to maximize the performance of queries

You are designing a partitioning strategy for a large fact table in a Manufacturing data warehouse.
Tens of millions of new inventory fact records are loaded into the data warehouse weekly, outside of business
hours.
Most queries against the database 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.)

You are designing a partitioning strategy for a large fact table in a Manufacturing data warehouse.
Tens of millions of new inventory fact records are loaded into the data warehouse weekly, outside of business
hours.
Most queries against the database 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 inventory fact table by day, and compress each partition.

B.
Partition the inventory fact table by year.

C.
Partition the inventory fact table by month, and compress each partition.

D.
Partition the inventory fact table by week.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


MicrosoftAnswer

MicrosoftAnswer

OK