正确答案: D
Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.
题目：You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform. ad hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.
解析：解析：Explanation:WeshouldsetupSQL2asalinkedserver.Thiswouldenabletoissuedistributedqueriestoit.WeshouldalsoselectRemoteCollationoptiontousethecollationontheremoteserver.Note:SQLServer2000allowsthecreationoflinkstoOLEDBdatasourcescalledlinkedservers.AfteralinkhasbeencreateditispossibletoreferencerowsetsfromtheOLEDBdatasourcesastablesinTransact-SQLstatementsandpasscommandstotheOLEDBdatasourcesandincludetheresultingrowsetsastablesinTransact-SQLstatements.Eachdistributedquerycanreferencemultiplelinkedserversandcanperform.eitherupdateorreadoperationsagainsteachindividuallinkedserver.Asingledistributedquerycanperform.readoperationsagainstsomelinkedserversandupdateoperationsagainstotherlinkedservers.Thelinkedserveroptionsdefinedbyusingthesp_serveroptionstoredprocedurecontrolhowSQLServerusescollationsfromlinkedservers.WhentheUseRemoteCollationoptionissettoTRUE,itspecifiesthatthecollationofremotecolumnsisusedforSQLServerdatasources,andthecollationspecifiedinCollationNameisusedfordatasourcesotherthanSQLServer.WhenFALSE,distributedqueriesalwaysusethedefaultcollationofthelocalserverinstance,andCollationNameandthecollationofremotecolumnsareignored.IftheUseRemoteCollationoptionissettoTRUE,wecanspecifythenameofthecollationusedbytheremotedatasourceintheCollationNameoption.Thecollationmust,however,besupportedbySQLServer.ThisoptionshouldbeusedwhenaccessinganOLEDBdatasourceotherthanSQLServer,butwhosecollationmatchesoneoftheSQLServercollationsIncorrectAnswers:A:TheCOLLATEclauseoftheALTERDATABASEstatementcanbeusedtochangethecollationusedbythedatabase.However,thissolutionisinappropriateastheSQL2servercontainsseveraldatabases,eachofwhichusesadifferentcollation.Wewouldthusnotbeabletospecifyallthecollations.B:Remoteserversaresetupinpairswithbothserversconfiguredtorecognizeeachotherasremoteservers.TheconfigurationoptionsforbothserversshouldbesetsothateachinstanceofSQLServerallowsremoteuserstoexecuteprocedurecalls.However,supportforremoteserversisprovidedforbackwardcompatibilityonly.ApplicationsthatmustexecuteproceduresagainstremoteinstancesofSQLServer2000shoulduselinkedserversinstead.D:InthisscenariowecannotspecifythecollationnameasSQL2containsseveraldatabases,eachofwhichuseadifferentcollation.
查看原题
举一反三的答案和解析：
[多选题]You have stored confidential financial data in a shared folder named AccSecured on your Windows 2000 Professional computer. Your company hires an intern named Richard. You create a subfolder named intern, which Richard needs to access. You want to allow Richard access to the intern subfolder only.You create a user account named intern. You want to allow the intern user account the ability to update, create, and delete files within the intern folder. You need to prevent Richard from accessing any other files or folders within the AccSecured folder.
Allow the intern user account modify permissions on the intern subfolder.
Allow the intern user account traverse folder/execute file permission on the AccSecured folder.
解析：解析：Explanation: The traverse folder/execute file permission" enables Richard to traverse the AccSecured folder to reach the intern folder, while the modify permissions on the intern folder allow Richard to modify information in the intern subfolder.
[单选题]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?
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 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.
[单选题]On a Windows 2000 Professional computer, you run a shipping application that prints packing labels to a laser printer for every outgoing shipment, 24 hours per day. During peak hours, your company ships more than 1,000 packages per hour.You have just purchased a second identical laser printer to aid in printing. You want to configure the printers so that the jobs are load balanced. You connect the second laser printer to the computer.
Enable printer pooling.
解析：解析：Explanation: To load balance print jobs on two printers you must create a printer pool. The printer pool will then automatically distribute the print jobs to the first available print device and the print jobs will be load balanced.
[单选题]You are the administrator of a Windows 2000 Active Directory network. The network consists of a single domain. The domain includes 20 Windows NT Workstation 4.0 client computers. All other client computers are Windows 2000 Professional computers.You create a Windows NT 4.0 default user policy on the Windows 2000 Server computer that is configured as the PDC emulator. This default user policy denies access to Network Neighborhood. You then install Terminal Services on one of the servers and Terminal Services Client on the 20 Windows NT Workstation client computers.
Create a Windows 2000 Group Policy that denies user access to My Network Places.
解析：解析：Explanation: Windows NT 4.0 system polices affect computers running Windows NT 4.0. The Windows NT computers in this scenario are being used as Terminals for the Windows 2000 Server computer that is running Terminal Services. In effect the Windows NT clients are running locally on the Windows 2000 Server. The restriction must be applied on the Windows 2000 Server. This can be done by using a group policy.
[单选题]Your Windows 2000 Professional computer has 10 shared folders that are available to other network users. A user reports that he cannot access a shared folder named Share
Use System Tools in Computer Management to display the file paths of your shared folders.
解析：解析：Explanation: The System Tools component of the Computer Management console can be used to locate shared folders. The Computer Management console can be accessed through the Administrative Tools applet in the Control Panel. In the Computer Management console, expand System Tools, expand Shared Folders and then open Shares to display all shared folders.
[单选题]You are the network administrator for Ezonexam.com. Your computer has a CD-ROM drive attached to a SCSI adapter. You plan to upgrade your computer from Windows NT Workstation 4.0 to Windows 2000 Professional. You determine that the SCSI adapter is not included on the current Hardware Compatibility List (HCL) and that the original SCSI drivers that you used for Windows NT are not compatible with Windows 2000 Professional.You want to upgrade your computer to Windows 2000 Professional.
Replace the SCSI adapter card with a Windows 2000 Professional compatible SCSI adapter. Start the installation from the Windows 2000 Professional CD-ROM. Add the new adapter card drivers when you are prompted.
解析：解析：Explanation: The hardware compatibility list (HCL) is a list of computers and peripherals that have been tested and have passed compatibility testing with the product for which the HCL is being developed. For example, the Windows 2000 HCL lists the products that have been tested and found to be compatible with Windows 2000. Before upgrading to Windows 2000, you should ensure that the computer hardware meets the minimum Windows 2000 hardware requirements. You must also check the Hardware Compatibility List or test the computers for hardware compatibility using the Windows 2000 Compatibility tool. Since the question mentions that the SCSI adapter is not included on the current HCL and that the original SCSI drivers, used for Windows NT is not compatible with Windows 2000, you should get a Windows 2000 Professional compatible SCSI adapter, start the installation of the Windows 2000 Professional CD-ROM and then add the new adapter card when prompted to do so.
[多选题]You are the administrator of your company's network. Your network has five Windows 2000 server computers and 75 Windows 2000 Professional computers. The Windows 2000 Professional computers were installed by using a RIS image on one of the Windows 2000 Server computers. You need to upgrade several applications on the Windows 2000 Professional computers. The applications do not have built-in support for scripted installations.You want to accomplish the following goals:
An unattended installation of the upgraded applications will be performed on the Windows 2000 Professional computers.
The RIS image and the upgraded applications will be enabled as they are added to the network.
解析：解析：Explanation: The following steps are taken:
