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

正确答案 ：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.

解析：解析：Explanation:

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

查看原题 点击获取本科目所有试题