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’ ;
Explanation:To estimate the size of the object if it were to use the requested compression setting, this stored procedure samples the source object and loads this data into an equivalent table and index created in tempdb. Sanfoundry Global Education & Learning Series – SQL Server.