Q101 Which compression option is best suited for this?

Q101 You want to use table compression suitable for OLTP that will: Compress rows for all DML statements on that table Minimize the overheads associated with compression

Which compression option is best suited for this?

• (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