YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2

单项选择题

YourcompanyhastwoSQLServer2005computersnamedSQL1andSQL2.TransactionlogshippingoccursfromSQL1toSQL2byusingdefaultSQLServerAgentschedulesettings.YouneedtoreconfiguretransactionlogshippingtoprovideminimumlatencyonSQL2.Whatshouldyoudo?（）
A.OnSQL1,reschedulethetransactionlogbackupjobsothatitoccurseveryminute.OnSQL2,maintaindefaultschedulesettingsforboththelogshippingcopyandtherestorejobs.
B.OnSQL1,changethescheduletypeforthetransactionlogbackuptoStartautomaticallywhenSQLServerAgentstarts.OnSQL2,changethescheduletypesforboththelogshippingcopyandtherestorejobstoStartautomaticallywhenSQLServerAgentstarts.
C.OnSQL1,maintaindefaultschedulesettingsforthetransactionlogbackupjob.OnSQL2,changethescheduletypesforboththelogshippingcopyandtherestorejobstoStartautomaticallywhenSQLServerAgentstarts.
D.OnSQL1,reschedulethetransactionlogbackupjobsothatitoccurseveryminute.OnSQL2,rescheduleboththelogshippingcopyandtherestorejobssothattheyoccureveryminute.

A.TransactionlogshippingoccursfromSQL1toSQL2byusingdefaultSQLServerAgentschedulesettings.YouneedtoreconfiguretransactionlogshippingtoprovideminimumlatencyonSQL2.Whatshouldyoudo?（）
A.OnSQL1,reschedulethetransactionlogbackupjobsothatitoccurseveryminute.OnSQL2,maintaindefaultschedulesettingsforboththelogshippingcopyandtherestorejobs.
B.OnSQL1,changethescheduletypeforthetransactionlogbackuptoStartautomaticallywhenSQLServerAgentstarts.OnSQL2,changethescheduletypesforboththelogshippingcopyandtherestorejobstoStartautomaticallywhenSQLServerAgentstarts.
C.OnSQL1,maintaindefaultschedulesettingsforthetransactionlogbackupjob.OnSQL2,changethescheduletypesforboththelogshippingcopyandtherestorejobstoStartautomaticallywhenSQLServerAgentstarts.
D.OnSQL1,reschedulethetransactionlogbackupjobsothatitoccurseveryminute.OnSQL2,rescheduleboththelogshippingcopyandtherestorejobssothattheyoccureveryminute.

相关考题

单项选择题根据应用环境的不同，访问控制可分为____。

单项选择题系统在国定条件下和过定时间内那规定的功能，这一树形指的是()。

单项选择题 Whatisthecorrectcommandtostopthecurrentlyexecutingjob'test'inJOBSjobstreamonalocalmachine？（）

单项选择题 Youneedtoidentifypotentialsecuritythreats.WhichofthefollowingsecuritybreachesmightoccurunderthecurrentITandsecuritypractices？（Chooseallthatapply）（）

单项选择题 YournetworkconsistsofasingleActiveDirectorydomainnamedcontoso.com.AllserversrunWindowsServer2003ServicePack2（SP2）.ThedomainhastwodomaincontrollersnamedDC1andDC2.BothdomaincontrollersareDNSservers.WindowsSupportToolsisinstalledonbothdomaincontrollers.Thecontoso.comDNSzoneisActiveDirectory-integrated.Youneedtoverifythatthecontoso.comzonehasreplicatedbetweenDC1andDC2.Whatshouldyoudo？（）A.OnDC1andDC2，openEventViewerandreviewtheDNSserverlog.B.OnDC1，opentheDNSsnap-in.Fromthepropertiesofthecontoso.comzone，reviewtheZoneTransfersettings.C.OnDC1andDC2，opentheDNSsnap-in.Fromthepropertiesofthecontoso.comzone，reviewtheMonitoringsettings.D.FromActiveDirectoryReplicationMonitor，connecttoDC1.UndertheDC=DomainDnsZones，DC=contoso，DC=comdirectorypartition，reviewthestatusofDefault-First-Site/DC2.

计算机考试试题及答案解析