[单选题]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 from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.

正确答案 ：F

On the server in Sydney, install an OLE DB provider for the mainframe. database.

解析：解析：Explanation: OLE DB is an API that allows COM applications to use data from OLE DB data sources, which includes data stored in different formats. An application uses an OLE DB provider to access an OLE DB data source. An OLE DB provider is a COM component that accepts calls to the OLE DB API and performs the necessary processing required by request against the data source. In this scenario the OLE DB source is the company's mainframe. database, which contains all company data. As each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database, all existing and future branch office SQL Server 2000 servers will require an OLE DB provider to access the company's mainframe. database.

[单选题]You are the administrator of Ezonexam's network. You want to deploy a Windows 2000 Professional service pack to 10 computers in the Development organizational unit.You create a Windows 2000 installer package file for the service pack. You use the package file to successfully install the service pack to other computers in the domain. You assign the package file to the Development organizational unit. After the installation, you notice that the service pack was not installed on any of the 10 computers.

正确答案 ：E

Add the user accounts from the Development organizational unit to a DACL. Grant the user accounts read permission to the service pack deployment directory.

解析：解析：Explanation: Before users can access resources on Windows 2000, they must be assigned the appropriate permissions to those resources. In this scenario the users from the Development OU need to be assigned read permission to the deployment directory, which is an object, to be able to start the installation process. Objects, such as the deployment directory, use a DACL (discretionary access control list) to check whether users or groups have been allowed or denied permissions to the object that they are attempting to access. Therefore, the user accounts of the Development OU must be added to the DACL of the deployment folder.

[单选题]You have 17GB of private files on drive D on your Windows 2000 Professional computer. You have shared the files as private_files. You do not want other users to see this share name in the browse list.You want all other share names to continue to appear in the browser list.What should you do?

正确答案 ：C

Change the share name to private_files$.

解析：解析：Explanation: By appending a dollar sign to the end of the share name, the share is hidden and the folder will not be shown in any browse list. Only users who know the folder name can gain access to it if they also possess the proper permissions to it.

[单选题]You are the administrator of Ezonexam.com's Windows 2000 network.Your computer is configured to use both Windows 2000 Professional and Windows NT Workstation 4.0 Service Pack 3. Your computer has three hard disks: Disk 0, Disk1, and Disk2. Windows NT Workstation 4.0 is installed on Disk 0. Windows 2000 Professional is installed on Disk1. You want to store your project files on Disk2. You configure Disk2 as a basic volume and format the volume as NTFS in Windows 2000 Professional. You then start Windows NT Workstation 4.0. You find that you cannot access your project files.

正确答案 ：C

Upgrade Windows NT Workstation 4.0 to Service Pack 4 or later.

解析：解析：Explanation: Windows 2000 Professional uses the NTFS 5.0 file system while Windows NT Workstation 4.0 uses the NTFS 4.0 file system. Windows NT Workstation requires Service Pack 4 or later to be able to use the NTFS 5.0 file system.

[单选题]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?

正确答案 ：A

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.

[单选题]You are preparing to install Windows 2000 Server on a new computer. The computer is connected to a network that includes Windows 98 computers and Windows 2000 Server computers.You want to install Windows 2000 Server from source files that are located on a server on the network.

正确答案 ：C

Start the new computer by using Windows 98 network boot disk. Connect to the network server. Run Winnt.exe.

解析：解析：Explanation: To install Windows 2000 Server on a computer from source files that are located in a centralized network location we would have to create a network boot disk that includes DOS drivers for the network adapter. We would have to start the computer using this boot disk and connect to the network share where the source files are located. Finally we would start installation process by using winnt.exe. We must use winnt.exe and not winnt32.exe 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.exe.

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

正确答案 ：C

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

解析：解析：Explanation:Whensettingupanewmasterserver,theoldmasterservermustdefectallitstargetservers.Whenanewlydesignatedmasterserverreplacesanexistingmasterserver,thetargetserversmustbedefectedfromtheexistingmasterserver.Thetargetserverscanthenbeenlistedonthenewmasterserver.Thiscanincludetheexistingtargetserver.Note:InSQLServer2000EnterpriseEdition,multiserveradministrationisusedtoautomatetheadministrationofmultipleinstancesofSQLServer2000.Itcanbeusedtomanagetwoormoreserversandtoscheduleinformationflowsbetweenenterpriseserversfordatawarehousing.Withmultiserveradministration,theremustbeatleastonemasterserverandatleastonetargetserver.Amasterserverdistributesjobstoandreceiveseventsfromtargetservers.Amasterserverstoresthecentralcopyofjobdefinitionsforjobsrunontargetservers.Targetserversconnectperiodicallytotheirmasterservertoupdatetheirlistofjobstoperform.Ifanewjobexists,thetargetserverdownloadsthejobanddisconnectsfromthemasterserver.Afterthetargetservercompletesthejob,itreconnectstothemasterserverandreportsthestatusofthejob.WithSQLServer2000EnterpriseEdition,masterserverscanenlisttargetserversandcandefecttargetservers.IncorrectAnswers:B:ThissolutiondoesnotaddresstheneedtodemotetheNewYorkCityserver.Itisthusstillamasterserver.C:InthissolutiontheJobMasterserverisenlistedasatargetserveroftheNewYorkCityserver.ThissolutionalsodoesnotaddresstheneedtodemotetheNewYorkCityserver.Itisthusstillamasterserver.D:InthissolutiontheNewYorkCityserverisnotatargetserveroftheJobMasterserverasithasbeendefectedfromtheJobMasterserver.

[单选题]You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?

正确答案 ：A

Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.

解析：解析：Explanation: Transfers can be defined and stored in a DTS package, which can then be run from a command line using the dtsrun utility (DTSRUN.EXE). CmdExec job steps are operating system commands or executable programs ending with .bat, .cmd, .com, or .exe. In this scenario we create a job consisting of a single cmdexec job step which runs the DTS package using the dtsrun utility.

[单选题]You are the administrator of a Windows 2000 network. Your network includes 75 Windows NT Workstation 4.0 computers. You are adding 50 new PXE-compliant computers to the network. The hardware on each computer is configured identically.You are using a RIS image to deploy Windows 2000 Professional to the 50 computers. You successfully install Windows 2000 Professional on the first 10 computers. However, you cannot install Windows 2000 Professional on remaining 40 computers.

正确答案 ：B

Configure the DHCP scope to add additional IP addresses.

解析：解析：Explanation: RIS requires Active Directory, DNS and DHCP. The clients can either be PXE-compliant or they can use a Remote boot diskette. In this scenario, the DHCP server has run out of IP-addresses. By extending the scope by 40 IP addresses the installation on the remaining computers will be successful.

[多选题]The network consists of a single domain named Ezonexam.com that includes 20 Windows NT workstation 4.0 client computers. All other client computers are Windows 2000 Professional computers. You install Terminal Services on one of the Windows Server computers and Terminal Services Client on the 20 Windows NT Workstation 4.0 client computers. You create a system policy on the server that is configured as the terminal server. This system policy denies access to Network Neighborhood. You find that the users of the terminal server can still browse the network when they open My Network Places from Windows 2000 Professional computer or when they open Network Neighborhood from Windows NT Workstation 4.0 computers.You want to prevent all users from browsing the network.

正确答案 ：BD

Create a Windows Group Policy that denies user access to My Network Places.

Create a Windows NT 4.0 default user policy on the Windows 2000 Server computer that is configured as the PDC emulator.

解析：解析：Explanation: The primary domain controller (PDC) is the server that maintains the master copy of the domain's user-accounts database and that validates logon requests. Prior to Windows 2000 every Windows NT network domain was required to have one, and only one, PDC. If you want to deny users of the terminal server browsing ability of the Network Neighborhood, you should create a group policy that denies access to My Network Places. (Microsoft is colloquially stuck with Network Neighborhood for My Network Places.)

查看原题