You have an Azure SQL database. The database contains a table that uses a columnstore index and is accessed infrequently. You enable columnstore archival compression. What are two possible results…

Question

Options

• AQueries that use the index will consume more disk I/O.
• BQueries that use the index will retrieve fewer data pages.
• CThe index will consume more disk space.
• DThe index will consume more memory.
• EQueries that use the index will consume more CPU resources.

• A
  6% (1)
• B
  67% (12)
• C
  17% (3)
• D
  11% (2)

Explanation

For rowstore tables and indexes, use the data compression feature to help reduce the size of the database. In addition to saving space, data compression can help improve performance of I/O workloads because the data is stored in fewer pages and queries need to read fewer pages from 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://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression

No community discussion yet for this question.