You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.

You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)

A．Apply a bulk update lock to the table.

B．Use separate client connections to load the files into the table simultaneously.

C．Create a clustered index on the table.

D．Specify the Full Recovery model for the database.

E．Specify the Bulk-Logged Recovery model for the database.

[单选题]You are the administrator of a new Microsoft Windows 2000 Server computer named CPSRV1.C．PSRV1 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 compa

[单选题]You are the administrator of a new Microsoft Windows 2000 server computer named HQSQL5. HQSQL5 is a member server in your company's Windows NT 4.0 domain, which is named HQMAIN.A．fter installing SQL Server 2000 on HQSQL5, you configure the MSSQLServ

[单选题]You are a systems administrator and you are about to assign static IP addresses to various servers on your network. For the network 192.168.20.24/29 the router is assigned to the first usable host address, while the last usable host address goes to y

[单选题]You are an administrator of the Ezonexam switched network and your goal is to reduce some of the administrative overhead on your network. You plan on achieving this by configuring a new VLAN for each department in the Ezonexam network.H．owever, you n

[单选题]You are the administrator of the homeoffice.local domain. You want to create a shared printer for the company's executives so that they do not have to wait for their documents to print when the default printer's queue contains a large number of doc

[单选题]You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A． Data Transforma

[单选题]You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and ad

[单选题]You are the workstation administrator at Ezonexam. You administer a Windows 2000 Professional computer named VE1.VE1 has a shared color laser printer named Printer1. You need to print a document immediately. The print queue for Printer1 has ten jobs

[单选题]You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data fr

[单选题]You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.B．ecause you have had power interruptions in the past, you want to perfect the phy