正确答案: CF

Implement snapshot replication. Schedule replication to run during off-peak hours.

题目：You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.

解析：解析：Explanation:

查看原题

举一反三的答案和解析：

[单选题]You need to install Windows 2000 Professional on 30 new computers. You also need to deploy a Windows 2000 Professional service pack during the installation.First, you create a network distribution folder named InstallFiles. You copy the i386 folder from the Windows 2000 Professional CD to the InstallFiles folder.

From an existing client computer, run theUpdate -s:InstallFilescommand from the service pack to the InstallFiles folder.

解析：解析：Explanation: Service pack slipstreaming refers to a service pack being integrated with an updated version of Windows 2000 on a CD-ROM or on a network share. When Windows 2000 is installed from either source, the appropriate files from the service pack are installed without having to manually apply the service pack after the installation. To apply a new service pack, run Update.exe with the -s:distribution_folder switch, where distribution_folder is the name of the folder that contains the Windows 2000 installation files.

[单选题]You are the administrator of a network that consists of a single Windows NT 4.0 domain. The network contains five Windows NT Server domain controllers and 1,000 Windows NT Workstation client computers.You want to install Windows 2000 Server on a new computer. You want the new computer to act as domain controller in the existing domain.

On the new computer, install Windows NT Server 4.0 and designate the computer as a BDC in the existing domain. Promote the computer to the PDC of the domain. Upgrade the computer to Windows 2000 Server.

解析：解析：Explanation:ToinstallaWindows2000computerasadomaincontrollerinaWindowsNT4.0domain,wemustfirstinstallWindowsNT4.0thecomputerasaBDCintheWindowsNT4.0domainandthenpromotetheBDCtoPDC.WemustthenupgradethemachinetoWindows2000Server.WhenupgradingthedomaincontrollersinaWindowsNTdomaintoWindows2000,wemustupgradetheprimarydomaincontrollerfirst.Incorrectanswers:B:ThecomputermustbeinstalledasBDCandthenlaterpromotedtoPDC.C:ThecomputermustfirstbeinstalledasaWindowsNT4.0BDCandthenpromotedtoPDC.D:ThecomputermustfirstbeinstalledasaWindowsNT4.0BDCandthenpromotedtoPDC.

[单选题]You are the administrator of your company's network. A user named Lilly prints dozens of documents daily from her Windows 2000 Professional computer. Lilly reports that she receives a dialog box announcing that each print job she sends has printed successfully.Lilly's default printer is a shared printer that is connected to Windows 2000 Server computer. She wants to have this notification turned off because she prints so many documents.

In the server properties of the printer system folder, clear the Notify when remote documents are printed option.

解析：解析：Explanation:Toturnoffthenotificationthataprintjobhasprintedsuccessfullyyoumustclearthe"Notifywhenremotedocumentsareprinted"optionontheAdvancedtabofthePrintSeverproperties.ThePrintServerpropertiescanbeaccessedviatheFilemenuinthePrintersfolder.Incorrectanswers:B:Thisoptionspecifieswhetherthenotificationshouldbesenttothecomputerortheuser.Byclearingthissettingthenotificationwillbesenttotheuser.Youdonotwantthisnotificationtobesent.Thereforeyoushouldclearthe"Notifywhenremotedocumentsareprinted"option.C:Disablingthebidirectionalsupportoptionwillpreventtheprintdevicefromcommunicatingwiththeprinterontheserver.Theprinterwillstillbesendingnotificationmessagestousersoftheprinter.Thebidirectionalsupportoptionshouldbeenabledsothattheprintdevicecouldreportprinterproblemssuchlowtoneretc.D:TheadvancedprintingfeaturesoptionconcernsmetafilespoolingandoptionssuchPageOrder,BookletPrinting,andPagesPersheet.Disablingthisoptionwillnotdisablethenotificationofprintjobs.

[单选题]You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.

Configure SQLAgentMail to use a valid MAPI profile

解析：解析：Explanation:SQLAgentMailmustbeusedwhenmailstoredproceduresareusedtosendnotificationstooperatorsbye-mailorpager.InordertouseSQLAgentMail,amailprofilemustbeconfiguredforSQLServerAgenttousetoconnecttothemailserverandthemailservermustbeextendedMAPI-compliant.IncorrectAnswers:B:SQLMailprovidesawaytoreceivee-mailmessagesgeneratedbySQLServer2000.Messagescanbetriggeredtoprovideinformationaboutthestatusofajoborawarningcausedbyanalert.SQLMailcanincludearesultsetinareplytoe-mailmessagesthatcontainqueriesandallowsSQLServertosendandreceivee-mailbyestablishingaclientconnectionwithamailserver.However,SQLMailmusthaveamailprofilecreatedinthesameuserdomainaccountorcontextthatisusedtostartaninstanceofSQLServer2000asitlooksforthedefinedmailprofileinthedomainaccountthattriggeredthee-malmessage.C:Netsendisusedtosendsmessagestootherusers,computers,ormessagingnamesacrossanetwork.TheMessengerservicemustberunningtoreceivemessages.Itisnotusedfore-mailorpagingpurposes.D:Thexp_startmailstoredprocedureisusedtostartaSQLMailclientsession.Ifthereisanexistingmailsession,xp_startmaildoesnotstartanewone.IfmailisbeingusedonthesamecomputeronwhichSQLServerisalsorunning,themailclientmustbestartedeitherbeforexp_startmailisexecuted,orbeforeSQLServerisstartedifSQLMailisconfiguredtoautomaticallystartwhenSQLServerstarts.

[单选题]You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.

Ensure that write caching disk controllers have battery backups.

解析：解析：Explanation:Thescenariostatesthatpowerinterruptionshaveoccurredinthepast.Bybuyingabatterybackupsolutionforthediskcontrollersthepowerinterruptionproblemwouldbeprevented.IncorrectAnswers:A:Tornpagedetectionisareactivesolutionwhichwouldslowdownperformancesincerestoreswouldhavetobemade.Itwouldbettertouseapreventivesolution.Note:Tornpagedetection:Ifatornpageisdetected,thedatabasemustberestoredfrombackupbecauseitwillbephysicallyinconsistent.B:Cachingisveryimportforperformance.Disablingwrite-cachingwouldbeabadidea.D:Repairingthedatabaseeverynightisnotagoodsolution.Databaseerrorscannotbeaccepted.Itisbettertopreventtheprobleminsteadoftryingtofixitafterithashappened.

[单选题]You are the administrator of a network that includes Windows NT Server 4.0 computers, Windows NT Workstation 4.0 computers, and UNIX computers. The network consists of a single Windows NT domain.You are upgrading a Windows NT Server computer named Server1 to Windows 2000 Server. Server1 is a BDC in the domain. The existing DNS server is a UNIX computer that supports SRV (service) records and is configured to accept dynamic updates. The existing WINS server is another Windows NT Server computer.

Promote Server1 to the PDC of the domain. Run Windows 2000 Setup on Server1.

解析：解析：Explanation: We want to upgrade the NT domain to an Active Directory domain; particularly we want to migrate the NT user accounts. First we need to promote server1 to PDC since it contains the master copy of domain information - SAM. Then upgrade the PDC to Windows 2000 Server. Active Directory requires a DNS server that supports SRV (service records). The UNIX DNS server supports this.