Which statement should you use?

You are a database developer on an instance of SQL Server 2008. You created the TrxHistory table using the following statement:
CREATE TABLE Inventory.TrxHistory (
ID int PRIMARY KEY,
TrxID int,
TrxDesc varchar(50),
TrxAmt money,
TrxDate datetime,
UpdID int);
The table has become extremely large and you want to minimize the storage it requires.
You want to determine the storage savings if you implemented page-level compression for the table.
Which statement should you use?
A. EXEC sp_estimate_data_compression_savings ‘Inventory’, ‘TrxHistory’, NULL, NULL, ‘PAGE’;
B. EXEC sp_estimate_data_compression_savings ‘Inventory.TrxHistory’, ‘PAGE’;
C. EXEC sp_estimate_data_compression_savings ‘Inventory’, ‘TrxHistory’;
D. EXEC sp_spaceused N’Inventory.TrxHistory’;

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.