Microsoft
DP-300 · Question #33
DP-300 Question #33: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #33. The question stem and answer options stay visible for context.
Submitted by minji_kr· Mar 6, 2026Monitor, configure, and optimize database resources
Question
You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table. FactSales has 6 billion rows and is loaded nightly by using a batch process. Which type of compression provides the greatest space reduction for the database?
Exhibit
Options
- Apage compression
- Brow compression
- Ccolumnstore compression
- Dcolumnstore archival compression
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.