-
1
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.
请帮忙给出正确答案和分析,谢谢!
-
2
You are the network administrator for Ezonexam. You are installing Windows 2000 Server on a new computer by using the Windows 2000 Server compact disk. The computer has five 18-GB hard disks Dick0, Disk1, Disk2, Disk3, and Disk4. The disks do not have any partitions defined.
You want to use as much space on Disk0 as possible for the partition on which Windows 2000 Server is installed. You want the disk on which you install Windows 2000 Server to be fault tolerant. You also want as much disk space as possible across the other disks to be available for data storage and to be fault tolerant.
What should you do? (Each correct answer presents part of the solution. Choose three)
A. Install Windows 2000 Server on a 4-GB NTFS partition on Disk 0. Configure the five disks as dynamic disks.
B. Install Windows 2000 Server on a 18-GB NTFS partition on Disk 0. Configure the five disks as dynamic disks.
C. Create a RAID-5 volume using Disk2, Disk3, and Disk4.
D. Create a stripped volume using Disk2, Disk3, and Disk4.
E. Create a RAID-5 volume using all disks.
F. Create a stripped volume using all disks.
G. Select the volume on Disk0 and add a mirror using Disk1.
请帮忙给出正确答案和分析,谢谢!
-
3
You are the network administrator for Ezonexam.
ServerEzonexam14 is a Windows NT Server 4.0 computer. ServerEzonexam14 is also a member server in a Windows 2000 domain named marketing.Ezonexam.local. The marketing.Ezonexam.local domain also has five Windows NT Server 4.0 backup domain controllers.
You want to upgrade ServerEzonexam14 to a Windows 2000 member server in the marketing.Ezonexam.local domain. You also want to be able to implement Universal Groups in the marketing.Ezonexam.local domain.
What should you do? (Each correct answer presents part of the solution. Choose three)
A. Reinstall Windows NT Server 4.0 on ServerEzonexam14 in the same WINNT folder, and make ServerEzonexam14 a BDC in the marketing domain.
B. Run the Active Directory Installation Wizard to make ServerEzonexam14 a domain controller in the marketing.Ezonexam.local domain.
C. Run the Active Directory Installation Wizard to convert ServerEzonexam14 to a domain controller in the fabrikam.local domain.
D. Upgrade all the Windows NT Server 4.0 backup domain controllers in marketing.Ezonexam.local to Windows 2000 Server.
E. Upgrade all the Windows NT Server 4.0 backup domain controllers in Ezonexam.local to Windows 2000 Server.
F. Upgrade ServerEzonexam14 to Windows 2000 Server.
G. Upgrade the marketing.Ezonexam.local domain to native mode.
请帮忙给出正确答案和分析,谢谢!
-
4
You are the domain administrator for Ezonexam.com. The network contains a Windows 2000 domain and two Windows NT domains. The Windows 2000 domain trusts each of the Windows NT domains, and the Windows NT domains trust the Windows 2000 domain.
You are required to configure one of the Windows 2000 domain controllers named Ezonexam4 to support several legacy applications that are not Windows 2000 certified.
What should you do? (Select two. Each answer specifies a complete solution).
A. On Ezonexam4, type secedit /configure /db secedit.sdb /cfg
C:\winnt\security\templates\hisecdc.inf /overwrite.
B. On Ezonexam4, type secedit /configure /db secedit.sdb /cfg
C:\winnt\security\templatescompatws.inf /overwrite.
C. On Ezonexam4, use the Security Configuration and Analysis snap-in to apply the Compatws.inf security template.
D. On Ezonexam4, use the Security Configuration and Analysis snap-in to apply the Hisecdc.inf
E. On Ezonexam4, use the Security Templates snap-in to open the Compatws.inf security template.
F. On Ezonexam4, use the Security Templates snap-in to open the Hisecdc.inf security template.
请帮忙给出正确答案和分析,谢谢!
-
5
You are the administrator of a Windows 2000 Server computer named Ezonexam1. A printer named PrinterColor is configured on Ezonexam1.
You want to allow only users in the Administrators group and users in the Managers group to print to PrinterColor. You also want to allow users in the Managers group to pause and resume their print jobs, and you want to ensure that users in the Administrators group have full control permission for PrinterColor.
What should you do?
To answer, click the Simulation button and then perform. the appropriate actions in the simulation of the Printers folder.
请帮忙给出正确答案和分析,谢谢!
-
6
You are the administrator of a SQL Server 2000 database. You import a table of geographic information from a Microsoft access database into a SQL Server 2000 database. The table has 12,000 rows. Each row averages 5,000 bytes. The table contains lockup data that does not change.
You want to minimize the size of the data file and the time required to back up the data. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)
A. Create a 60-MB data file named geography.ndf
B. Create a 95-MB data file named geography.ndf
C. Create a 60-MB data file named geography.mdf
D. Create a 95-MB data file named geography.mdf
E. Place the table in the PRIMARY filegroup.
F. Place the table in a new filegroup named LOCATION.
请帮忙给出正确答案和分析,谢谢!
-
7
You are the administrator of a Windows 2000 Server network at Ezonexam.
You configure a server named print10.marketing.Ezonexam.com.local as a print server at the Los Angeles office. You create and share printers on the server for use by employees in the marketing,Ezonexam.local domain.
You want to review the configured properties of all of the shared printers on the print10.marketing.Ezonexam.local server. You want to perform. this review from a Windows 2000 Professional computer at the London office of Ezonexam.
What can you do? (Each correct answer presents a complete solution. Choose two)
A. Use your Web browser to connect to http://print10.london.Ezonexam.local/printers/.
B. Use your Web browser to connect to http://print10.marketing.Ezonexam.local/printers/.
C. Run the net view \\print10 command.
D. Run the net view \\print10.marketing.Ezonexam.com command.
E. Browse to \\print10.marketing.Ezonexam.local and open the Printers folder.
F. Browse to \\print10.london.Ezonexam.local and open the Printers folder.
请帮忙给出正确答案和分析,谢谢!
-
8
You are the desktop administrator of your Windows 2000 Professional computer.
On your computer you have a printer named LaserJet that is attached to your local LPT1 port. You have shared LaserJet and given Print permission to the Sales group. You are a member of the Sales group. On many occasions you find that you have to wait a long time for your print jobs because there are several jobs ahead of yours. You create a second printer named LaserJet2 using LPT1 port and the default settings.
You want to ensure that you do not have to wait for other print jobs before your print jobs can complete.
What should you do? (Each correct answer presents part of the solution. Choose two)
A.Grant only your account Print permission to LaserJet2.
B.Deny Print permission to the Sales group on LaserJet2.
C.Configure LaserJet to Start printing after last page is spooled.
D.Configure LaserJet to Print directly to the printer.
E.Set the priority of LaserJet to 10.
F.Set the priority of LaserJet2 to 99.
请帮忙给出正确答案和分析,谢谢!
-
9
You are the network administrator for Ezonexam. The network includes a Microsoft Windows NT Server 4.0 member server computer that has a non-Plug and Play ISA network adapter.
You want to upgrade this computer to Microsoft Windows 2000 Server. You also want to ensure that you maintain the current device configuration during the upgrade.
What should you do? (Each correct answer presents part of the solution. Choose two)
A. Install the latest driver for the network adapter.
B. Disable the network adapter.
C. Start the upgrade process by using Winnt32.exe
D. Start the upgrade process by booting from the Windows 2000 Server compact disc.
E. Configure BIOS to reserve the IRQ currently in use by the network adapter.
F. Press F6 at the beginning of the text mode setup to specify an additional driver.
请帮忙给出正确答案和分析,谢谢!
-
10
You are the administrator of a Windows 2000 Professional computer that is shared by several users in the Sales department. User accounts have been created for current users. Current users can log on to the computers. To accommodate new users, you add two new user accounts named User7 and User8 to computer5. When User7 attempts to log on o the computer, she receives the following error message: "Windows cannot copy file C:\Documents and Settings\Default User\ to location C:\Documents and Settings\User7. Contact your network administrator. Detail - Access is denied." When User8 attempts to log on to the computer, he receives the same type of error message.
You want to allow the two new users, as well as other users in the Sales department, to be able to log on to the computer.
Which two methods can you use to accomplish your goal? (Choose two.)
A.Add the User7 and User8 user accounts to the DACL for the Profiles shared folder on the network server.
B.Add the User7 and User8 user accounts to the DACL for the C:\Documents and Settings\Default User folder.
C.Add the Everyone group to the DACL for the C:\Documents and Settings\Default User folder.
D.Add a Group Policy object (GPO) for the Sales OU that redirects user profiles to a shared folder.
E.Log on by using the local Administrator account and create new folders for User7 and User8 in the C:\Documents and Settings folder.
F.Select the allow inheritable permissions from parent to propagate to this object option on the C:\Documents and Settings\Default User folder, and reset the permissions on all child objects.
G.Move and retain permissions and compressions.
请帮忙给出正确答案和分析,谢谢!