正确答案: BF

Enable the Always read properties from UDL file option in the Connection Properties dialog box. Make the .udl files available on a network share.

题目：You are the administrator of several SQL Server 2000 computers. A data Transformation Services (DTS) package uses native OLE DB providers to transfer data between the servers. Connection details for the servers are specified in .udl files. The .udl files are frequently updated as connection details change.You want to distribute the DTS package as a file to developers in your company. You want to make sure connection details are available to developers who receive the DTS package.

解析：解析：Explanation:

查看原题查看所有试题

学习资料的答案和解析：

[单选题]You are the desktop administrator for Ezonexam.com'ssalesdepartment. Ezonexam.com's network contains a RIS server.You need to install Windows 2000 Professional on a computer that has a SCSI disk subsystem. You start the computer by using the Windows 2000 Professional CD-ROM, and you begin the installation.

Start the computer by using the Windows 2000 Professional CD-ROM, and run Setup. After Setup starts, provide a SCSI-controller driver on a floppy disk.

解析：解析：Explanation: The problem here is that Windows 2000 doesn't have a driver for the SCSI-controller and so can't find a hard disk to install onto. We can solve this problem by providing a driver during the installation. During the text mode part of the installation, you will see the option to "Press F6 to install a third party SCSI driver".

[单选题]Your network includes Windows 98 computers and Windows 2000 Server computers. You are adding a new computer to the network, and you plan to install Windows 2000 Server on the new computer. The computer has one 20-GB hard disk with no partitions defined.The Windows 2000 Server CD-ROM is unavailable. You want install Windows 2000 Server from source files that are located on a server on the network. You also want the entire hard disk of the new computer to be used for the system partition.

Start the new computer by using a Windows 98 network boot disk. Create and format a single FAT32 partition. Connect to the network server. Run Winnt.exe.

解析：解析：Explanation: To install Windows 2000 Server on computers from source files that are located on a centralized network share we would have to connect to the network share from the the computers. If the computers do not have PXE-compliant network cards we would have to make a network boot disk that the computers can use connect to the network share. We would start the installation process by using winnt with /s /u /udf switches. We must use winnt and not winnt32 as the boot disks operate in DOS mode, which works with 16-bit applications. We would thus not be able to use 32-bit applications like winnt32.

[多选题]You are the administrator of a Windows NT Server 4.0 computer named Ezonexam1.Ezonexam1 is a backup domain controller and a member of Ezonexam.com's Windows 2000 Active Directory forest. The forest consists of three Windows 2000 domains. Ezonexam1 is the only remaining Windows NT Server 4.0. A new version of the application that runs on Windows 2000 Server has been developed that requires the use of Universal groups. The application will not run on a domain controller.

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

Convert the Windows 2000 domains to native mode.

解析：解析：Explanation: A member server is a Windows Server 200 server that has been installed as a non-domain controller and joined to a domain. This allows the server to operate as a file, print, and application server without the overhead of account administration.

[单选题]You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?

Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.

解析：解析：Explanation:Detachingandattachingdatabasesissometimesausefultechniqueforquicklymovingadatabasefromonecomputertoanother.Tomoveadatabase,ordatabasefile,toanotherserverordiskthedatabasemustfirstbedetachedfromtheoriginalserverordisk;movedtotheotherserverordiskandthenattachedontheserverordisk.Inadditionthenewlocationofthemovedfile(s)mustbespecified.Thesp_detach_dbstoredprocedureisusedtodetachthedatabaseandcanrunUPDATESTATISTICSonalltablesbeforedetachingthedatabasewhilethesp_attach_dbstoredprocedureisusedtoattachthedatabaseinitsnewlocation.IncorrectAnswers:B:DTScanimportdatafromatextfileorfromanOLEDBdatasourcesuchasaMicrosoftAccess2000databaseintoSQLServer.ItcanalsoexportdatafromSQLServertoanOLEDBdatadestination.Itprovidesforhigh-speeddataloadingfromtextfilesintoSQLServertables.However,itisnotthefastestwaytomoveawholedatabasefromoneservertoanother.C:Beforeadatabasecanberestoredfromabackuptoanewlocation;thedatabasemustfirstberecreatedinthedestinationasthebackupholdsonlythedatafilesthatbelonginthevarioustables.Itdoesnotholdthetabledefinitions.Thisisnotthefastestmethodtomoveadatabase.D:TheDISKINITandDISKREFITcommandscannotbeusedtomoveadatabasefromoneservertoanother.Note:DISKINITandDISKREINITarefeaturesthatareusedinaSQLServer6.x.inSQLServer6.x,DISKINITisusedtocreatedatabaseortransactionlogdevicestostorethespecifieddatabaseortransactionlogwhenDISKINITfollowedeitheraCREATEDATABASEorALTERDATABASEstatementwhileDISKREINITisusedtorestoredeviceentriestoappropriatesystemtableswhenthedeviceentrywasmissingfromsysdevices.InSQLServer2000theCREATEDATABASEandALTERDATABASEstatementsallowforthecreationofseparatedataandlogfiles.BothCREATEDATABASEandALTERDATABASEcreateoperatingsystemfilesanddatabasesinasinglestep.ItisthusrecommendedthatallreferencestoDISKINITshouldberemovedinSQLServer2000andreplacedwithreferencestoeitherCREATEDATABASEorALTERDATABASE.