當前位置: 首頁 > 問題分類 > 計算機類考試 > 微軟認證 > 問題詳情
問題

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.

參考答案
正確答案:F
F 解析:Explanation: The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.

Note: The BULK INSERT statement is used to copy a data file into a database table or view in a format specified by the user. The BULK INSERT statement accepts the TABLOCK hint, which allows the user to specify the locking behavior. that the BULK INSERT statement should use. TABLOCK specifies that a bulk update table-level lock is taken for the duration of the bulk copy. If TABLOCK is not specified, the default uses row-level locks.

Incorrect Answers:
A, B, C, D: Effect would not be large
E: Some improvement, but not the best answer.
G: Would make the batch to stop working.
您可能感興趣的試題
  • 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 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.

新疆十一选五和值表