单项选择题
You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services （SSAS） database. A cube in the database contains a large dimension named Customers. The database uses a data source that is located on a remote server. Each day， an application adds millions of fact rows and thousands of new customers. Currently， a full process of the cube takes several hours. You need to ensure that queries return the most recent customer data with the minimum amount of latency. Which cube storage model should you use？（）
A. hybrid online analytical processing （HOLAP）
B. relational online analytical processing （ROLAP）
C. multidimensional online analytical processing （MOLAP）
D. automatic multidimensional online analytical processing （automatic MOLAP）
相关考题
-
单项选择题
YoudesignaBusinessIntelligence（BI）solutionbyusingSQLServer2008.ThesolutioncontainsaSQLServer2008AnalysisServices（SSAS）database.Ameasuregroupinthedatabasecontainslogentriesofmanufacturingevents.Theseeventsincludeaccidents，machinefailures，productioncapacitymetrics，andotheractivities.Youneedtoimplementadataminingmodelthatmeetsthefollowingrequirements：Predictthefrequencyofdifferenteventtypes.Identifyshort-termandlong-termpatterns.Whichalgorithmshouldthedataminingmodeluse？（）
A. the Microsoft Time Series algorithm
B. the Microsoft Decision Trees algorithm
C. the Microsoft Linear Regression algorithm
D. the Microsoft Logistic Regression algorithm -
单项选择题
YoudesignaBusinessIntelligence（BI）solutionbyusingSQLServer2008.ThesolutionincludesaSQLServer2008AnalysisServices（SSAS）database.ThedatabasecontainsadataminingstructurethatusesaSQLServer2008tableasadatasource.AtablenamedOrderDetailscontainsdetailedinformationonproductsales.TheOrderDetailstableincludesacolumnnamedMarkup.YoubuildadataminingmodelbyusingtheMicrosoftDecisionTreesalgorithm.YouclassifyMarkupasdiscretizedcontent.ThealgorithmproducesalargenumberofbranchesforMarkupandresultsinlowconfidenceratingsonpredictablecolumns.YouneedtoverifywhethertheMarkupvaluesincludeinaccuratedata.Whatshouldyoudo？（）
A. Modify the content type of Markup as Continuous.
B. Create a data mining dimension in the SSAS database from OrderDetails.
C. Create a data profile by using SQL Server 2008 Integration Services （SSIS）.
D. Create a cube in SSAS. Use OrderDetails as a measure group. Recreate the data mining structure and mining model from the cube data. -
单项选择题
YoudesignaSQLServer2008ReportingServices（SSRS）solution.YoucreateareportbyusingMicrosoftVisualStudio.NET2008.Thereportcontainsthefollowingcomponents：AdatasetnamedCustomerthatlistsallactivecustomersandtheirdetails.Thedatasetacceptsnoparameters.AdatasetnamedSalesHistorythatlistsallsalestransactionsforaspecifiedtimeperiodandacceptsyearandmonthasparameters.Youneedtoensurethatasummaryofsalestransactionsisdisplayedforeachcustomerafterthecustomerdetails.Whichcomponentshouldyouaddtothereport？（）
A. List
B. Table
C. Matrix
D. Subreport
