相关考题

单项选择题 YoudesignaBusinessIntelligence(BI)solutionbyusingSQLServer2008.ThesolutionincludesaSQLServer2008AnalysisServices(SSAS)database.AcubeinthedatabasecontainsalargedimensionnamedCustomers.Thedatabaseusesadatasourcethatislocatedonaremoteserver.Eachday,anapplicationaddsmillionsoffactrowsandthousandsofnewcustomers.Currently,afullprocessofthecubetakesseveralhours.Youneedtoensurethatqueriesreturnthemostrecentcustomerdatawiththeminimumamount of latency.Whichcubestoragemodelshouldyouuse?()

单项选择题 YoudesignaBusinessIntelligence(BI)solutionbyusingSQLServer2008.ThesolutioncontainsaSQLServer2008AnalysisServices(SSAS)database.Ameasuregroupinthedatabasecontainslogentriesofmanufacturingevents.Theseeventsincludeaccidents,machinefailures,productioncapacitymetrics,andotheractivities.Youneedtoimplementadataminingmodelthatmeetsthefollowingrequirements:Predictthefrequencyofdifferenteventtypes.Identifyshort-termandlong-termpatterns.Whichalgorithmshouldthedataminingmodeluse?()

单项选择题 YoudesignaBusinessIntelligence(BI)solutionbyusingSQLServer2008.ThesolutionincludesaSQLServer2008AnalysisServices(SSAS)database.ThedatabasecontainsadataminingstructurethatusesaSQLServer2008tableasadatasource.AtablenamedOrderDetailscontainsdetailedinformationonproductsales.TheOrderDetailstableincludesacolumnnamedMarkup.YoubuildadataminingmodelbyusingtheMicrosoftDecisionTreesalgorithm.YouclassifyMarkupasdiscretizedcontent.ThealgorithmproducesalargenumberofbranchesforMarkupandresultsinlowconfidenceratingsonpredictablecolumns.YouneedtoverifywhethertheMarkupvaluesincludeinaccuratedata.Whatshouldyoudo?()