black

MCTS(70-452)

单项选择题

You design a Business Intelligence （BI） solution by using SQL Server 2008. 
The solution includes a SQL Server 2008 Analysis Services （SSAS） database. The database contains a cube named Financials. The cube contains objects as shown in the exhibit. （Click the Exhibit button.） 
A calculated member named Gross Margin references both Sales Details and Product Costs. You need to ensure that the solution meets the following requirements： 
Managers must be able to view only their cost centers percentage of the companys gross margin.  The impact on query performance is minimal. What should you do？（）

A. Add dimension-level security and enable the Visual Totals option.
B. Add cell-level security that has read permissions on the Gross Margin measure.
C. Add cell-level security that has read contingent permissions on the Gross Margin measure.
D. Change the permissions on the Managers dimension level from Read to Read/Write.

相关考题

单项选择题 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？（）

All Rights Reserved 版权所有©PP题库网库(pptiku.com)

备案号：湘ICP备14005140号-5

经营许可证号：湘B2-20140064