Exam DP-300 topic 1 question 3 discussion

it is D MS Docs : For columnstore tables and indexes, all columnstore tables and indexes always use columnstore compression and this is not user configurable. Use columnstore archival compression to further reduce the data size for situations when you can afford extra time and CPU resources to store and retrieve the data. You can configure columnstore archival compression.

Question may have been changed recently and now requires "...and maximize performance." Only columnstore compression can achieve both "...greatest reduction in database space and maximize performance." "Columnstore compression typically achieves 10x better compression rates over rowstore indexes. It is the standard compression method for columnstore indexes and enables fast query performance." https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-design-guidance?view=sql-server-ver16. Therefore C. appears to be a better answer than D.

Since maximize performance is in requirements, I would go with C. Who knows, if you pick columnstore archival, maybe their batch loading will take too long and cause problems :D p.s. bad question, bad job by whoever made it

https://learn.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-ver16 "When you compress columnstore indexes with archival compression, this causes the index to perform slower than columnstore indexes that don't have the archival compression. Use archival compression only when you can afford to use extra time and CPU resources to compress and retrieve the data. The benefit of archival compression is reduced storage, which is useful for data that isn't accessed frequently. For example, if you have a partition for each month of data, and most of your activity is for the most recent months, you could archive older months to reduce the storage requirements"

The answer is D

The question info statement makes the point that you must provide the greatest reduction in space for the database and maximise performance. But the actual "question" is asking you to state "which type of compress provides the greatest space reduction for the database?" ... its an awful question setup by Microsoft, but based on the interpretation it's D

D. Question is for maximum compression; not which compression meets the requirements.

Columnstore with archive not give performance, while they asked for maxim compression with performance, Hence (C) option is the best suit.

D. columnstore archival compression

Correct answer D, because it provides the greatest space reduction.

It seems they added “and maximise performance” to the question, so it should be C?

Where mentioned that is column store or row store table?

it is C to reduce space usage and improve performance.

it is D

it is D

Think it´s D Columnstore tables and indexes are always stored with columnstore compression. You can further reduce the size of columnstore data by configuring an additional compression called archival compression. https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-ver15

D is the right answer because the question is asking 'Which type of compression provides the greatest space reduction for the database'