<< Prev Question Next Question >>

Question 24/26

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?

LEAVE A REPLY

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

Question List (26q)
Question 1: You have a Microsoft Azure SQL data warehouse that has a fac...
Question 2: Note: This question is part of series of questions that pres...
Question 3: You plan to use Microsoft Azure Event Hubs to ingest sensor ...
Question 4: You manage an on-premises data warehouse that uses Microsoft...
Question 5: You need to use the Cognition.Vision.FaceDetector() function...
Question 6: You have a Microsoft Azure SQL data warehouse stored in geo-...
Question 7: You have a Microsoft Azure SQL data warehouse named DW1 that...
Question 8: You have a Microsoft Azure SQL data warehouse to which 1,000...
Question 9: Note: This question is part of series of questions that pres...
Question 10: You are designing a data loading process for a Microsoft Azu...
Question 11: Note: This question is part of series of questions that pres...
Question 12: Note: This question is part of series of questions that pres...
Question 13: You plan to create several U-SQL jobs. You need to store str...
Question 14: You have a Microsoft Azure Data Factory pipeline that has an...
Question 15: You have a Microsoft Azure SQL data warehouse. You need to c...
Question 16: Note: This question is part of series of questions that pres...
Question 17: You need to connect to a Microsoft Azure SQL data warehouse ...
Question 18: You have a Microsoft Azure Data Lake Analytics service. You ...
Question 19: Note: This question is part of series of questions that pres...
Question 20: You have a Microsoft Azure Data Lake Analytics service. You ...
Question 21: You have a file in a Microsoft Azure Data Lake Store that co...
Question 22: You plan to use Microsoft Azure Event Hubs in Azure Stream A...
Question 23: You are using Cognitive capabilities in U-SQL to analyze ima...
Question 24: You have a fact table named PowerUsage that has 10 billion r...
Question 25: You plan to deploy a Microsoft Azure virtual machine that wi...
Question 26: You have a 2-TB text file stored in Microsoft Azure Blob sto...