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…

Question

Options

• Apage compression
• Bcolumnstore compression
• CGZIP compression
• Dcolumnstore archival compression

• A
  4% (2)
• B
  15% (8)
• C
  8% (4)
• D
  73% (38)

Explanation

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. https://learn.microsoft.com/en-us/sql/relational-databases/data-compression/data- compression?view=sql-server- ver16#:~:text=For%20columnstore%20tables%20and%20indexes%2C%20all,to%20store%20an d%20retrieve%20the%20data. Both columnstore and columnstore archival compression can be indexed but archival achieves the max compression ratio. There's also no requirement for performance, so the slowness of archival compression is acceptable.

No community discussion yet for this question.