You are designing a fact table named FactPurchase in an Azure Synapse Analytics dedicated SQL pool. The table contains purchases from suppliers for a retail store. FactPurchase will contain the following columns.

FactPurchase will have 1 million rows of data added daily and will contain three years of data.
Transact-SQL queries similar to the following query will be executed daily.SELECT - SupplierKey, StockItemKey, IsOrderFinalized, COUNT(*) FROM FactPurchase - WHERE DateKey >= 20210101 - AND DateKey <=2 0210131 - GROUP By SupplierKey, StockItemKey, IsOrderFinalized
Which table distribution will minimize query times

Question

You are designing a fact table named FactPurchase in an Azure Synapse Analytics dedicated SQL pool. The table contains purchases from suppliers for a retail store. FactPurchase will contain the following columns.

FactPurchase will have 1 million rows of data added daily and will contain three years of data.
Transact-SQL queries similar to the following query will be executed daily.


SELECT -
  
SupplierKey, StockItemKey, IsOrderFinalized, COUNT(*)
 
FROM FactPurchase -
 
WHERE DateKey >= 20210101 -
 
AND DateKey
 <=2 0210131 - 
GROUP By SupplierKey, StockItemKey, IsOrderFinalized

Which table distribution will minimize query times

Examsnet · Accepted Answer

Correct Answer is :  hash-distributed on PurchaseKey

Data Engineering on Microsoft Azure DP-203 Practice Test 1