LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 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 containing a large heap fact table with 50 columns and 5 billion rows. Most queries aggregate values from around 100 million rows and return only two columns. These queries are performing very slowly.

What type of index should you add to achieve the fastest query performance?

Exam-Like



Powered ByGPT-5