1. [单选题]You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which your company has placed bids.Company 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.
A. What should you do?
B. Create a Data Transformation Services (DTS) package to remove bids that have a closing data older than one year.
C. 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.
D. 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.
E. Create a view that contains a WHERE clause to exclude bids that have a closing date older than one year.
2. [单选题]You are the administrator of a network that consists of Windows 2000 Server Computers and Windows 2000 Professional computers.You want to configure the deployment of the most recent Windows 2000 Service pack so that users of the Windows 2000 Professional Computers receive the service pack automatically when they log on to the domain.
A. What should you do?
B. Create a Microsoft Windows installer package for the service pack. Configure RIS to use the package.
C. Create a Microsoft Windows installer package for the service pack. Configure the package in a group policy.
D. Create a Microsoft Windows installer package for the service pack. Configure the package in the local computer policy.
E. Place the service pack in a distributed file system (Dfs).
3. [多选题]You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change.You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package.
A. Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two)
B. Enable the Always read properties from UDL file option in the Connection Properties dialog box.
C. Disable the Always read properties from UDL file option in the Connection Properties dialog box.
D. Delete the .udl files and store connection details in the registry by using system data source names.
E. Delete the .udl files, and store connection details in the registry by using user data source names.
F. Make the .udl files available on a network share.
