微软认证70-228模拟试卷3

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. In this database, the Parts table has a primary key that is used to identify each part stored in the company's warehouse. Each part has a unique UPC code that your company's accounting department uses to identify it. The database is configured as shown in the exhibit.

You want to maintain the referential integrity between the Parts table and the OrderDetails table. You want to minimize the amount of physical I/O that is used within the database.

Which two Transact-SQL statements should you execute? (Each correct answer represents part of the solution. Choose two.)

A. CREATE UNIQUE INDEX IX_UPC On Parts(UPC)

B. CREATE UNIQUE INDEX IX_UPC On OrderDetails(UPC)

C. CREATE TRIGGER UPCRI On OrderDetails

 FOR INSERT, UPDATE As

 If Not Exists (Select UPC From Parts

 Where Parts.UPC = inserted.UPC) BEGIN

 ROLLBACK TRAN

 END

D. CREATE TRIGGER UPCRI On Parts

 FOR INSERT, UPDATE As

 If Not Exists (Select UPC From Parts

 Where OrderDetails.UPC = inserted.UPC) BEGIN

 ROLLBACK TRAN

 END

E. ALTER TABLE dbo.OrderDetails ADD CONSTRAINT

 FK_OrderDetails_Parts FOREIGN KEY(UPC)

 REFERENCES dbo.Parts(UPC)

F. ALTER TABLE dbo.Parts ADD CONSTRAINT

 FK_Parts_OrderDetails FOREIGN KEY (UPC)

 REFERENCES dbo.Parts(UPC)

You are the administrator of a new Microsoft Windows 2000 server computer named HQSQL5. HQSQL5 is a member server in your company's Windows NT 4.0 domain, which is named HQMAIN.

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)

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 system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.

You want the package to execute automatically each evening at 8:00 P.M. What should you do?

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?

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?

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?