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

You are the administrator of three SQL Server 2000 computers at Five Lakes Publishing. One server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.

You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.

Which two actions should you take? (Each correct answer presents part of the solution. Choose two)

You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration exhibit.

You need to create a new database named Inventory. Employees in your company will use the Inventory database to track inventory data. Users will require immediate responses to queries that help them locate where parts are stored. The tables in the database will be configured as shown in the Database Schema exhibit.

The database will consume 14 GB of disk space. You must configure the data files and transaction log to accelerate query response time.

Which two courses of action should you take? (Each correct answer represents part of the solution. Choose two.)

A. On drive C, create a transaction log.

 On drive D, create a data file in the PRIMARY filegroup.

 On drive E, create a data file in the SECONDARY filegroup.

B. On each drive, create a transaction log.

 On each drive, create a data file in the PRIMARY filegroup.

C. On drive D, create a transaction log.

 On drive E, create a data file in the PRIMARY filegroup.

D. On the PRIMARY filegroup, create all tables and all indexes.

E. On the PRIMARY filegroup, create all tables. On the SECONDARY filegroup, create all indexes.

F. On the PRIMARY filegroup, create the Parts table and its indexes.

 On the SECONDARY filegroup, create all other tables and their indexes.

You are the administrator of a SQL server computer. The server is running SQL Server 6.5 and SQL Server 7.0.

You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.

You cancel the SQL Server upgrade wizard.

You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?

You are the administrator of a SQL Server 2000 computer. The server contains a database that has the torn page detection database option enabled. Backups of the database are made daily.

The server loses power for one minute. When power is restored, torn pages are detected. You notice in SQL Server Enterprise Manager that the database is marked suspect.

You need to correct the problem. What should you do?

You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. The database is configured as shown in the exhibit.

In the last six months, the database has grown by 4 GB. Users report that query response time has slowed. The options set up on the database are shown in the Database Options exhibit.

You want to accelerate query response time. What should you do?

Exhibit:

UPDATE EzonexamConsolidated

SET District = ‘Mexico’

WHERE RtvID = 45

You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.

When users run the query in the exhibit above the receive the following error message:

Server: Mrh3612, Level 16, Stats 1, Line 1

View or function ‘EzonexamConsolidated’ is not updateable because it

contains aggregates:

How should you enable the query to run?

You are the administrator of a SQL Server 2000 database. Using the default options configures the database. You drop indexes to facilitate a large import of data, and rebuild them after the import is complete.

Users report that response times from a stored procedure have become slower. In the stored procedure, you examine the following code.

CREATE PROCEDURE GetCustomer

( @CustomerID Int )

You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.

You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.

While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started.

You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do?