Microsoft
70-776 · Question #20
You have a Microsoft Azure SQL data warehouse that has a fact table named FactOrder. FactOrder contains three columns named CustomerId, OrderId, and OrderDateKey. FactOrder is hash distributed on…
Sign in or unlock 70-776 to reveal the answer and full explanation for question #20. The question stem and answer options stay visible for context.
Operate and manage Big Data solutions
Question
You have a Microsoft Azure SQL data warehouse that has a fact table named FactOrder. FactOrder contains three columns named CustomerId, OrderId, and OrderDateKey. FactOrder is hash distributed on CustomerId. OrderId is the unique identifier for FactOrder. FactOrder contains 3 million rows. Orders are distributed evenly among different customers from a table named dimCustomers that contains 2 million rows. You often run queries that join FactOrder and dimCustomers by selecting and grouping by the OrderDateKey column. You add 7 million rows to FactOrder. Most of the new records have a more recent OrderDateKey value than the previous records. You need to reduce the execution time of queries that group on OrderDateKey and that join dimCustomers and FactOrder. What should you do?
Options
- AChange the distribution for the FactOrder table to round robin.
- BUpdate the statistics for the OrderDateKey column.
- CChange the distribution for the FactOrder table to be based on OrderId.
- DChange the distribution for the dimCustomers table to OrderDateKey.
Unlock 70-776 to see the answer
You've previewed enough free 70-776 questions. Unlock 70-776 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Azure SQL Data Warehouse#query optimization#statistics#hash distribution