Question 23:
You want to use table compression suitable for OLTP that will: 1. Compress rows for all DML statements on that table 2. Minimize the overheads associated with compression Which compression option is best suited for this?
Answer options:
A. COLUMN STORE COMPRESS FOR QUERY LOW B. ROW STORE COMPRESS BASIC C. COLUMN STORE COMPRESS FOR ARCHIVE LOW D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH E. ROW STORE COMPRESS ADVANCED