You have an Azure SQL database. The database contains a table of analytical data that must be retained. You need to implement a data compression solution that maximizes a reduction in storage. Which t

The correct answer is B. columnstore archive. Columnstore archive provides the maximum data compression in an Azure SQL Database when query performance is not the top priority. While columnstore compression is already highly efficient for analytical workloads, the archive option further reduces the data size, but at the cost

Submitted by kwame.gh· Mar 6, 2026Monitor, configure, and optimize database resources

Question

You have an Azure SQL database. The database contains a table of analytical data that must be retained. You need to implement a data compression solution that maximizes a reduction in storage. Which type of compression should you use?

Options

Apage
Bcolumnstore archive
Crow
Dcolumnstore

How the community answered

(26 responses)

A
4% (1)
B
92% (24)
C
4% (1)

Explanation

Columnstore archive provides the maximum data compression in an Azure SQL Database when query performance is not the top priority. While columnstore compression is already highly efficient for analytical workloads, the archive option further reduces the data size, but at the cost of increased compression and decompression time. https://brainly.com/question/61706068

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice