DP-300 Certification Practice Question #3

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. You must provide the greatest reduction in space for the database and maximize performance.
Which type of compression provides the greatest space reduction for the database?

Accepted Answer

Although the preamble mentions the desire to "maximize performance," the direct question asks: "Which type of compression provides the greatest space reduction for the database?". Columnstore archival compression (Option D) applies an additional level of compression (Xpress algorithm) on top of the standard columnstore compression (Option C), thereby achieving the absolute greatest reduction in storage footprint.

More DP-300 practice questions