Explanation:Use sp_estimate_data_compression_savings to estimate the savings that can occur when you enable a table or partition for row or page compression. 10. Which of the following query estimates the size of the Production.WorkOrderRouting table if it is compressed by using ROW compression ?
A. EXEC sp_estimate_data_compression_savings ‘Production’, ‘WorkOrderRouting’, NULL, NULL, ‘ROW’ ;
B. EXEC sp_estimate_data_compression_savings ‘Production’, ‘WorkOrderRouting’, NULL, 1, ‘ROW’ ;
C. EXEC sp_estimate_data_compression_savings ‘Production’, ‘WorkOrderRouting’, 1, NULL, ‘ROW’ ;
D. EXEC sp_estimate_data_compression_savings ‘Production’, ‘WorkOrderRouting’, NULL, NULL, ‘COLUMN’ ;
Answer:A
Explanation:Use sp_estimate_data_compression_savings to estimate the savings that can occur when you enable a table or partition for row or page compression. 10. Which of the following query estimates the size of the Production.WorkOrderRouting table if it is compressed by using ROW compression ?
A. EXEC sp_estimate_data_compression_savings ‘Production’, ‘WorkOrderRouting’, NULL, NULL, ‘ROW’ ; B. EXEC sp_estimate_data_compression_savings ‘Production’, ‘WorkOrderRouting’, NULL, 1, ‘ROW’ ; C. EXEC sp_estimate_data_compression_savings ‘Production’, ‘WorkOrderRouting’, 1, NULL, ‘ROW’ ; D. EXEC sp_estimate_data_compression_savings ‘Production’, ‘WorkOrderRouting’, NULL, NULL, ‘COLUMN’ ;