
Ultimate access to all questions.
You are designing a fact table named FactPurchase in an Azure Synapse Analytics dedicated SQL pool for a retail store. The table will contain purchase data from suppliers with the following columns:
PurchaseKeySupplierKeyStockItemKeyDateKeyPurchaseQuantityPurchaseAmountThe table will have 1 million rows of data added daily and will contain three years of data. Daily Transact-SQL queries similar to the following will be executed:
SELECT
SupplierKey,
StockItemKey,
COUNT(*)
FROM FactPurchase
WHERE DateKey >= 20210101
AND DateKey <= 20210131
GROUP BY SupplierKey, StockItemKey
SELECT
SupplierKey,
StockItemKey,
COUNT(*)
FROM FactPurchase
WHERE DateKey >= 20210101
AND DateKey <= 20210131
GROUP BY SupplierKey, StockItemKey
Which table distribution type will minimize query times?*
