[多选题]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.)

正确答案 ：ABE

Apply a bulk update lock to the table.

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

Specify the Bulk-Logged Recovery model for the database.

解析：解析：Explanation:

[单选题]You are the administrator of a Windows NT Server 4.0 computer named Ezonexam1. Ezonexam1 is a backup domain controller (BDC), and a member of Ezonexam.com's Windows 2000 Active Directory domain. Ezonexam1 contains five hard disks. Disk 0 and 1 are configured as a Windows NT 4.0 mirror set.The mirror set contains the operating system files and 500 MB of free disk space. Disk 2, 3 and 4 are configured as a Windows NT 4.0 stripe set with parity and contain employee data files. The Windows NT 4.0 stripe set with parity has a maximum capacity of 140 GB and contains 15 GB of free disk space.

正确答案 ：F

Upgrade Ezonexam1 to Windows 2000 Server. During the upgrade, select the option to make Ezonexam1 a domain controller. After the upgrade is complete, demote Ezonexam1.

解析：解析：Explanation: We upgrade Ezonexam1. We have no choice that the upgraded Windows 2000 Server will be a domain controller. We are then able to use the dcpromo.exe utility to remove the Active Directory and demote the Domain controller to a member server.

[单选题]You are the administrator of the Coho Vineyard network. The network consists of 10 Windows 2000 Advanced Server computers and 250 Windows 2000 Professional computers.Your company has two domains cohovineyard.com and westcoastsales.com.

正确答案 ：D

Add cohovineyard.com to the Domain Suffix Search Order on the computers.

解析：解析：Explanation: ServerA is located in the domain cohovineyard.com. If you add cohovineyard.com to the domain suffix then http://ServerA will translate to http://ServerA.cohovineyard.com, which would resolve this problem. This configuration can be done by opening TCP/IP properties, selecting the Advanced button, selecting the DNS tab, selecting 'Append these DNS Suffixes (inorder)', selecting Add, and entering cohovineyard.com

查看原题