LeetQuiz Logo
About•Privacy Policy•contact@leetquiz.com
RedditX
© 2025 LeetQuiz All rights reserved.
Microsoft Azure Data Engineer Associate - DP-203

Microsoft Azure Data Engineer Associate - DP-203

Get started today

Ultimate access to all questions.


Comments

Loading comments...

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:

  • PurchaseKey
  • SupplierKey
  • StockItemKey
  • DateKey
  • PurchaseQuantity
  • PurchaseAmount

The 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?*

Exam-Like
Quiz related visual



Powered ByGPT-5