MicrosoftMicrosoft
DP-300 · Question #80
DP-300 Question #80: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #80. The question stem and answer options stay visible for context.
Submitted by carter_n· Mar 6, 2026Optimize query performance
Question
You have an Azure SQL database. The database contains a table that uses a columnstore index and is accessed infrequently. You enable columnstore archival compression. What are two possible results of the configuration? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Options
- AQueries that use the index will consume more disk I/O.
- BQueries that use the index will retrieve fewer data pages.
- CThe index will consume more disk space.
- DThe index will consume more memory.
- EQueries that use the index will consume more CPU resources.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.