Microsoft
70-776 · Question #15
You have a fact table named PowerUsage that has 10 billion rows. PowerUsage contains data about customer power usage during the last 12 months. The usage data is collected every minute. PowerUsage…
The correct answer is C. Implement partitioning by using the MonthKey column. See the full explanation below for the reasoning.
Question
You have a fact table named PowerUsage that has 10 billion rows. PowerUsage contains data about customer power usage during the last 12 months. The usage data is collected every minute. PowerUsage contains the columns configured as shown in the following table. LocationNumber has a default value of 1. The MinuteOfMonth column contains the relative minute within each month. The value resets at the beginning of each month. A sample of the fact table data is shown in the following table. There is a related table named Customer that joins to the PowerUsage table on the CustomerId column. Sixty percent of the rows in PowerUsage are associated to less than 10 percent of the rows in Customer. Most queries do not require the use of the Customer table. Many queries select on a specific month. You need to minimize how long it takes to find the records for a specific month. What should you do?
Exhibits
Options
- AImplement partitioning by using the MonthKey column.
- BImplement partitioning by using the CustomerId column.
- CImplement partitioning by using the MonthKey column.
- DImplement partitioning by using the MinuteOfMonth column.
How the community answered
(25 responses)- B12% (3)
- C80% (20)
- D8% (2)
Community Discussion
No community discussion yet for this question.

