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

You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer.

Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific Net-Library, as shown in the following table.

You need to allow the client computers to connect to the SQL Server 2000 computer. You also want to minimize the number of configuration changes required on the client computers.

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

A. Install SQL Server 2000 as a named instance.

B. Install SQL Server 2000 as the default instance.

C. Configure the new instance for Mixed Mode Authentication.

D. Configure the new instance for Windows Authentication.

E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.

F. Configure the server to use the Multiprotocol Net-Library.

You are the administrator of a new Microsoft Windows 2000 Server computer named CPSRV1.

CPSRV1 is a member server in your company's Windows NT 4.0 domain, which is named CPDOMAIN. A separate Windows NT domain named CPUSERS contains all of your company's user accounts. A trust relationship exists between the CPDOMAIN domain and the CPUSERS domain.

You are installing SQL Server 2000 on CPSRV1.

You specify a service account for each SQL Server service as shown in the following table:

Exhibit:

BULK INSERT Ezonexam.dbo.employees

FROM ‘tk\africe\fubar512.txt’

WITH DATAFILETYPE = ‘char’,

FIELD/TERMINATOR = ‘\t’,

ROWTERMINATOR = ‘\n,’

TABLOCK

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

How should you improve the performance of the query in the exhibit above?

A. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 5 percent of the number of rows to be loaded.

B. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 10 percent of the number of rows to be loaded.

C. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 5 percent of the number of rows to be loaded.

D. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 10 percent of the number of rows to be loaded.

E. Insert a line before the BULK INSERT statement that drops the indexes for the customers table. Insert a line after the BULK INSERT statement that recreates the indexes for the customers table.

F. The TABLOCK option should be removed.

G. The ROWTERMINATOR line should be removed.

You are the administrator of a 12 SQL Server 2000 computers. These servers are located in company offices throughout the world.

You configure a multiserver job on the server in your company's New York City office. You configure this server as a master server, and designate the remaining 11 servers as target servers.

You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform. data tasks.

The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit.

You do not want the DTS package to add any data to the server unless both transform. data tasks complete successfully.

You select the use transactions check box of DTS package and the Join transaction of present check box of both transform. data tasks. You then select the fail package on step failure check box of both transform. data tasks.

You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed.

What should you do?

You are the administrator of a SQL Server 2000 computer. The server contains a database that is heavily indexed and that company users query extensively. The database has grown and query response time has slowed. The database is stored in a single data file.

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

You are the administrator of a SQL Server 2000 computer. The server contains a database named sales. Your company uses the database to store the sales department’s responses to requests for price quotations. The database is configured as shown in the exhibit.

Developers in your company create an application used for saving quotations. The application executes the following transact-SQL statement:

UPDATE QuotationSummary

SET CustomerName = ‘Jean-Paul Deloria’

WHERE QuotationID = 12

When the application executes the statement, the developers receive the following error:

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

View or function ‘QuotationSummary’ is not updateable because it contains aggregates:

You want developers to be able to use this UPDATE statement without generating errors. What should you do?

You are the administrator of SQL Server 2000 computer. The server contains a database named Inventory. The database has a set of tables that track the location of parts. The tables are configured as shown in the Database Schema exhibit.

You examine the indexes in the PartsLocations table. The indexes are configured as shown in the Indexes exhibit.

You also examine the contiguity of the PK_partsLocations index and receive the following results:

DBCC SHOWCONTIG scanning 'PartsLocations' table...

Table: 'PartsLocations' (1); index ID: 1, database ID: 6

TABLE level scan performed.

- Pages Scanned................................: 3000

- Extents Scanned..............................: 750

- Extent Switches..............................: 502

- Avg. Pages per Extent........................: 4.0

- Scan Density [Best Count:Actual Count].......: 33.33% [1:3]

- Logical Scan Fragmentation...................: 33.33%

- Extent Scan Fragmentation....................: 33.33%

- Avg. Bytes Free per Page.....................: 1166.0

- Avg. Page Density (full).....................: 85.77%

You need to improve the performance of the queries that join this table to the Parts table and the Locations table. What should you do?