YouuseaSQLServer2005databasenamedDB1,whichislocatedonaservernamedSQL1.DB1isinuse24hoursaday,7daysaweek.ArecentcopyofDB1existsonasecondservernamedSQLtestthatalsorunsSQLServer2005.YoudetectahighnumberoffullscansonSQL1andconcludethatadditionalindexesinDB1areneeded.AworkloadfilethatissuitableforDatabaseEngineTuningAdvisor(DTA)alreadyexists.
YouneedtoanalyzetheworkloadfilebyusingDTA.YoumustensuremaximumperformanceonSQL1duringanalysis.YoumustalsoensureavailabilityduringtheimplementationofanyrecommendationssuggestedbytheDTA.
Whatshouldyoudo?()
YourcompanysWindowsServer2003environmentconsistsofasingleActiveDirectorydirectoryserviceforest.TheforesthasmultipledomainsandthreesitesnamedSite1,Site2,andSite3.Site1isthemainofficeandhasfourdomaincontrollers.Twoofthedomaincontrollersareglobalcatalogservers.Site2isabranchofficewithtwodomaincontrollers.Site3isabranchofficewithaslowandunreliableWANlinkandtwodomaincontrollers.YouneedtoimproveuserlogonperformanceforusersinSite2andSite3.
Whichtwoactionsshouldyouperform?()
YourcompanyhasofficesinTorontoandChicago.BothofficesbelongtoanActiveDirectorydirectoryservicesitenamedSite1.ThereisonlyonedomaincontrollerinSite1.UsersintheChicagoofficeareexperiencingslowlogontimes.YoucreateanewActiveDirectorysitefortheChicagoofficenamedSite2.YoupromoteanewdomaincontrollerandcreateasitelinkbetweenSite1andSite2.YouneedtoimprovelogontimesfortheChicagousersandenableActiveDirectoryreplicationbetweentheSite1andSite2domaincontrollers.
Whichtwoactionsshouldyouperform?()