MCQOPTIONS
Saved Bookmarks
| 1. |
You are an administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur._x005F_x000D_ - A BULK INSERT job imports data at 10:00 P.M- Indexes are rebuilt at 10:15 P.M- Data integrity checks are performed at 10:30 P.M- A differential backup is performed at 10:45 P.M- A DBCC SHRINKDATABASE job runs at 11:00 P.M._x005F_x000D_ You notice that the final job often fails and returns the following error message: "Server: Msg 3140, Level 16, State 3. Could not adjust the space allocation for file 'inventory_data'."You need to ensure that the final job runs without errors._x005F_x000D_ What should you do? |
| A. | Modify the DBCC SHRINKDATABASE job so that it uses DBCC SHRINKFILE statement to shrink each file individually. |
| B. | Create a new DBCC SHRINKFILE job to shrink the inventory_data file. Schedule the new job to run at the same time as the DBCC SHRINKDATABASE job. |
| C. | Increase the time between the differential backup and the DBCC SHRINKDATABASE job. |
| D. | Increase the time between the data integrity checks and the differential backup. |
| Answer» D. Increase the time between the data integrity checks and the differential backup. | |