AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: One of the key benefits to columnstore indexes azure video

Question 1 Be Honest
« Back   Next azure Cloud dp-300-database-admin-assoc Question »
Answer

Full Certification Question

One of the key benefits to columnstore indexes is the ability to compress your data. In addition to columnstore compression, SQL Server offers a few other options for compressing data. While SQL Server still stores compressed data on 8 KB pages, when the data is compressed, more rows of data can be stored on a given page, which allows the query to read fewer pages. Reading fewer pages has a twofold benefit: it reduces the amount of physical IO performed it allows more rows to be stored in the buffer pool, making more efficient use of memory Which of the following are types data compression used in SQL Server? (Select three)