Question 172
DP-300 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →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.
- 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.