DP-300 Certification Practice Question #30

Question

You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet that uses partitioned columnstores.

You need to configure table1 to meet the following requirements:

•	Each partition must be compressed.
•	The compression ratio must be maximized.
•	You must be able to index the compressed data.

What should you use?

Accepted Answer

The question asks for maximum compression ratio while still being able to index the data. Columnstore archival compression (COLUMNSTORE_ARCHIVE) applies XPRESS algorithm on top of standard columnstore compression, achieving the highest possible compression ratio. Crucially, the requirement is just "must be able to index the compressed data" — not fast index access — and voodoo_sh's live test confirms nonclustered indexes can coexist with archival-compressed columnstore tables. GZIP (C) is the only option that truly prohibits indexing. Standard columnstore compression (B) achieves less compression than archival.

More DP-300 practice questions