Câu 64: DP-300: Administering Relational Databases on Microsoft Azure

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 of the configuration? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

1. A. Queries that use the index will consume more disk I/O.
2. B. Queries that use the index will retrieve fewer data pages. — đáp án hiện tại
3. C. The index will consume more disk space.
4. D. The index will consume more memory.
5. E. Queries that use the index will consume more CPU resources. — đáp án hiện tại