Which statement about adaptive compression is true?
A.
Adaptive compression uses a page-level dictionary-based compression algorithm to
compress data based on repeating patterns found within asampling of data from one extent.
B.
Adaptive compression can only be used to compress base tables, partitioned tables, and
temporary tables; MQTs, typed tables and stagingtables cannot be compressed.
C.
When you enable adaptive compression for a table, you enable it for the entire table,
even if the table contains more than one partition.
D.
You can specify that tables be compressed by using either a table-level dictionary only,
pagelevel dictionaries only, or both table-level andpage-level dictionaries.
Explanation: