Microsoft
DP-300 · Question #187
You have an Azure SQL database named DB1. You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled. During a database audit, you discover that none of
Sign in or unlock DP-300 to reveal the answer and full explanation for question #187. The question stem and answer options stay visible for context.
Submitted by jaden.t· Mar 6, 2026Monitor and optimize resources
Question
You have an Azure SQL database named DB1. You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled. During a database audit, you discover that none of the fields contain more than 150 characters. You need to ensure that you can apply page compression to Table1. What should you do?
Options
- AConfigure the columns as sparse.
- BChange the column type to nvarchar (MAX).
- CChange the column type to varchar (MAX).
- DChange the column type to varchar (200).
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.
Topics
#page compression#row compression#column data types#storage optimization