PrepAway - Latest Free Exam Questions & Answers

Which statement about adaptive compression is true?

Which statement about adaptive compression is true?

PrepAway - Latest Free Exam Questions & Answers

A.
When you enable adaptive compression for a table, you enable it for the entire table, even if the table
contains more than one partition.

B.
You can specify that tables be compressed by using either a table-level dictionary only, page-level
dictionaries only, or both table-level and page-level dictionaries.

C.
Adaptive compression can only be used to compress base tables, partitioned tables, and temporary tables;
MQTs, typed tables and staging tables cannot be compressed.

D.
Adaptive compression uses a page-level dictionary-based compression algorithm to compress data based
on repeating patterns found within a sampling of data from one extent.


Leave a Reply