You want to use table compression suitable for OLTP that will:1. Compress rows for all DML statements on that table2. Minimize the overheads associated with compressionWhich 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… Read More »
You want to use table compression suitable for OLTP that will:Compress rows for all DML statements on that tableMinimize the overheads associated with compressionWhich 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.… Read More »
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 compressionWhich compression option is best suited for this? A. COLUMN STORE COMPRESS FOR ARCHIVE HIGH B. ROW STORE COMPRESS ADVANCED C. ROW STORE COMPRESS BASIC D. COLUMN STORE COMPRESS FOR QUERY LOW E.… Read More »