You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which your company has placed bids.

C．ompany policy requires that bid information be removed permanently from the database one year after the bid closes. You need to comply with this policy and minimize server overhead.

What should you do?

A．Create a Data Transformation Services (DTS) package to remove bids that have a closing data older than one year.

B．Create a trigger to delete any bids that have a closing data older than one year. Bind the trigger to the bids table for all INSERT, UPDATE, and DELETE events.

C．Create a stored procedure to delete any bids that have a closing data order than one year. Use SQL server agent to schedule the stored procedure to run every night.

D．Create a view that contains a WHERE clause to exclude bids that have a closing date older than one year.

[单选题]You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes s

[单选题]You are the administrator of a SQL Server 2000 computer. You want to set up snapshot replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers.C．urrently, you want to publish 3GB of data, but the da

[单选题]You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that fu

[单选题]You are the administrator of a SQL Server 2000 computer. The server contains your company's order processing database. Two-hundred operators take orders by telephone 24 hours a day. Threehundred data entry personnel enter data from orders received b

[单选题]You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database s

[单选题]You are the administrator of a SQL Server 2000 computer. The server contains a database that stores financial data. You want to use Data Transformation Services packages to import numeric data from other SQL server computers. The precision and scale

[单选题]You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.You need to

[单选题]You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.You are also the administrator of Oracle relational database management system (RDBMS) server.This server is

[单选题]You are the administrator of a SQL Server 2000 computer. One of the databases on the server contains a table named complaints. This table is used to store information about customer complaints.The customer service representatives in your company add

[单选题]You are the administrator of a SQL Server 2000 computer. You are configuring a database for an inventory application. The hard disks on your server are configured as shown in the exhibit.The operating system files are located on drive C. Your databas

[单选题]You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sale