DP-300 · Question #450
DP-300 Question #450: Real Exam Question with Answer & Explanation
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
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
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.