Microsoft Exam 70-467 Topic 13 Question 3 Discussion

Actual exam question for Microsoft's 70-467 exam

Question #: 3
Topic #: 13

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.

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

BPartition the inventory fact table by day, and compress each partition.

CPartition the inventory fact table by year.

DPartition the inventory fact table by week.

Show Suggested Answer

Suggested Answer: B

by Rickie at May 09, 2022, 11:45 AM

Limited Time Offer

25%

Off

Get Premium 70-467 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!