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

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 your company's network. Your network has five Windows 2000 server computers and 75 Windows 2000 Professional computers. The Windows 2000 Professional computers were installed by using a RIS image on one of the Windows 2000 Server computers. You need to upgrade several applications on the Windows 2000 Professional computers. The applications do not have built-in support for scripted installations.

    You want to accomplish the following goals:

    1. An unattended installation of the upgraded applications will be performed on the Windows 2000 Professional computers.

    2. Existing user environments will be maintained on the Windows 2000 Professional computers.

    3. The network name of each Windows 2000 Professional computer will be changed to match its asset tag.

    4. The RIS image and the upgraded applications will be enabled as they are added to the network.

    You take the following actions:

    1. Install the RIS image on a Windows 2000 Professional computer named Computer1.

    2. Install the upgraded applications on Computers1.

    3. Change the network name of Computer1 to %DMI-SERIAL_NUM%.

    4. Run RIPrep.exe on Computer1 to load the RIS image on to the RIS server.

    5. Start all of the Windows 2000 Professional computers, and then load the RIS image from the RIS server.

    Which result or results do these actions produce? (Choose all that apply.)

    A.An unattended installation of the upgraded applications will be performed on the Windows 2000 Professional computers.

    B.Existing user environments will be maintained on the Windows 2000 Professional computers.

    C.The network name of each Windows 2000 Professional computer will be changed to match its asset tag.

    D.The RIS image and the upgraded applications will be enabled as they are added to the network.

  • You are the administrator responsible for security and user desktop settings on your network. You need to configure a custom registry entry for all users. You want to add the custom registry entry into a Group Policy object (GPO) with the least amount of administrative effort.

    What should you do?

    A.Configure an ADM template and add the template to the GPO.

    B.Configure an INF policy and add the policy to the GPO.

    C.Configure a Microsoft Windows installer package and add the package to the GPO.

    D.Configure RIS to include the registry entry.

  • You are the network administrator for Ezonexam. The network consists of a single Active Directory domain Ezonexam.com. All network servers run Windows Server 2000.

    Your network includes a shared folder named EzonexamDocs. This folder must not be visible in a browse list.

    However, users report that they can see EzonexamDocs when they browse for shared folders.

    How should you solve this problem?

    A.Modify the share permissions to remove the All - Read permission on EzonexamDocs from the Users group.

    B.Modify the NTFS permissions to remove the Allow - Read permissions on EzonexamDocs from the Users group.

    C.Change the share name to EzonexamDocs #.

    D.Change the share name to EzonexamDocs $.

  • On a Windows 2000 Professional computer, you run a shipping application that prints packing labels to a laser printer for every outgoing shipment, 24 hours per day. During peak hours, your company ships more than 1,000 packages per hour.

    You have just purchased a second identical laser printer to aid in printing. You want to configure the printers so that the jobs are load balanced. You connect the second laser printer to the computer.

    What must you do next?

    A.Enable bi-directional support.

    B.Enable printer pooling.

    C.Configure print spooling.

    D.Configure print sharing.

×
驗證
广西快乐双彩开奖30期