You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company.
The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.
How should you configure the database？
A. Configure the database on the two servers as a SQL Server 2000 cluster.
B. Configure the database on one server, and then configure a standby database on the second server.
Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.
D. Configure the database as a federated database, and then partition half the data on each server.
查看答案
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.
Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month.
You want to minimize the workload on the Publisher/Distributor. Which two actions should you take to configure snapshot replication？ (Each correct answer presents part of the solution. Choose two)
A. Store the snapshot in the default folder on the Publisher/Distributor.
B. Store the snapshot in an alternative folder on the Publisher/Distributor.
C. Store the snapshot in a shared folder on a file server.
D. Create pull subscriptions.
E. Create push subscriptions.
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 used to store your company’s financial information. The financial information is updated frequently throughout the day.
You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.
You want to create reports on the SQL Server computer by using the minimum amount of disk space.
What should you do？
A. Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.
B. Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.
C. Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.
D. Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.
You want the package to execute automatically each evening at 8:00 P.M. What should you do？
A. Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.
B. Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.
Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account
D. Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of data. The server has one 9-GB hard disk that is configured as shown in the Exhibit.
You need to import data into the database without adversely affecting database performance. The data will require an additional 2GB of storage space.
What should you do？
Add another data file on drive E, and then add the file to the PRIMARY filegroup.
B. Move the transaction log file to drive E, and set the file growth of Acc_Data.mdf by selecting the Unrestricted file growth option.
C. Rebuild all clustered indexes so that they have a fill factor of 100.
D. Compress drive D.
微信支付 
支付宝支付