当前位置: 首页 > 问题分类 > 计算机类考试 > 微软认证 > 问题详情
问题

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 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.

    After the job completes successfully, you decide to set up a new SQL Server 2000 computer as the master server. The new server will be named JobMaster and the other 12 servers will be target servers.

    You need to make the New York City server a target server instead of a master server. What should you do?

    A.On the New York City server, defect all 11 target servers. On the JobMaster server, enlist the 12 servers as target servers.

    B.On the JobMaster server, enlist all other servers as target servers.

    C.On the New York City server enlist the JobMaster server as a target server. Transfer the multiserver jobs from the New York City server to the JobMaster server.

    D.On the JobMaster server, enlist the New York City server as a target server. On the JobMaster server, enlist the other 11 servers as target servers. On the JobMaster server, defect the New York City server.

  • 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?

    A.Select the commit on successful completion check box of the DTS package.

    B.Select the commit transaction on successful completion of this step check box of the customers transform. data task.

    C.Select the commit transaction on successful completion of this step check box of the sales transform. data task.

    D.Select the commit transaction on successful completion of this step check box of both transform. data tasks.

  • Your network consists of numerous domains within a LAN, plus one remote location that is configured as another domain within the tree. Each domain contains several organizational units. The remote domain is connected to the main office network by using 56-Kbps connection, as shown in the Exhibit.

    The remote location is running a previous service pack for Windows 2000, and the LAN is running the most recent service pack.

    You want to configure a group policy for the remote location so that users can repair a problem with a service pack system file. You also want to reduce the traffic on the LAN and ease administration of the group policies. You want to retain the domain administrator's access to the group policy configuration.

    What should you do?

    A.Configure a group policy for each OU in the west.litware.com domain. Configure a service pack software package for each group policy.

    B.Configure a group policy for each OU in the litware.com domain. Configure a service pack software package for each group policy.

    C.Configure a group policy for west.litware.com domain. Configure a service pack software package for the group policy.

    D.Configure a group policy for the litware.com domain. Configure a service pack software package for the group policy.

  • 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?

    A.Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.

    B.Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.

    C.Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.

    D.Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.

×
验证