You want to use table compression suitable for OLTP that will:1. Compress rows for all DML statements on that table2. Mi

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You want to use table compression suitable for OLTP that will:1. Compress rows for all DML statements on that table2. Mi

Post by answerhappygod »

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 HIGH E. ROW STORE COMPRESS ADVANCED
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply

Return to “Archived Questions & Answers”