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 have an Azure Synapse Analytics dedicated SQL pool with a table named Table1. The table has the following properties:

  • Contains one billion rows
  • Uses a clustered columnstore index
  • Is hash-distributed on the Product Key column
  • Has a non-nullable column named Sales Date of the date data type

Thirty million new rows are added to Table1 monthly. You plan to partition Table1 on the Sales Date column to optimize both query performance and data loading.

How often should you create a partition?

Exam-Like



Powered ByGPT-5