YouareanalyzingtheperformanceofaSQLAzuredatabase.Youneedtorecommendanapproachforidentifyingtheindexesthatshouldbeaddedtoimprovedatabaseperformance.Whatshouldyourecommend?()A.UseSQLServerProfilertoidentifymissingindexes.B.UsetheDatabaseEngineTuningAdvisort
题目
YouareanalyzingtheperformanceofaSQLAzuredatabase.Youneedtorecommendanapproachforidentifyingtheindexesthatshouldbeaddedtoimprovedatabaseperformance.Whatshouldyourecommend?()
A.UseSQLServerProfilertoidentifymissingindexes.
B.UsetheDatabaseEngineTuningAdvisortoidentifymissingindexes.
C.UseaDynamicManagementViewtoanalyzequeryplans.
D.UseaDynamicManagementViewtoascertainthenumberofpendingI/Orequests.