YoudesignaBusinessIntelligence（BI）solutionbyusingSQLSer

单项选择题

You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）

A. Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.
B. Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.
C. Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.
D. Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.

相关考题

单项选择题 YoudesignaBusinessIntelligence（BI）solutionbyusingSQLServer2008.YoucreateaSQLServer2008ReportingServices（SSRS）solutionbyusingSQLServer2008.SeveralreportsontheserveruseashareddatasourcenamedDSProduction.YoumodifyanexistingreportthatusestheDSProductiondatasource.Afterdeployment，themodifiedreportmustuseanalternatedatasource.Youneedtopreventthemodifiedreportfromaffectingotherreports.Whatshouldyoudo？（）

单项选择题 YoudesignaBusinessIntelligence（BI）solutionbyusingSQLServer2008.YouplantocreateaSQLServer2008ReportingServices（SSRS）solution.Developersgeneraterandomreportsagainstadatasourcethatcontains200tables.Powerusersgeneraterandomreportsagainstfourofthe200tables.YouneedtodesignastrategyfortheSSRSsolutiontomeetthefollowingrequirements：·Usesminimumamountofdevelopmenteffort.·ProvidestwosetsoftablesinSSRStothedevelopersgroupandthepowerusersgroup.Whichstrategyshouldyouuse？（）

单项选择题 YoudesignaBusinessIntelligence（BI）solutionbyusingSQLServer2008.YoucreateaSQLServer2008ReportingServices（SSRS）solution.ThesolutioncontainsareportnamedSalesDetailsthatdisplayssalesinformationofalltheemployees.YoucreateanSSRSreportnamedSalesSummarythatdisplaysthetotalmonthlysalesofeachemployee.UserswhoviewtheSalesSummaryreportoccasionallyrequirethemonthlysalesdetailsforaparticularemployee.YouneedtoensurethattheuserscanclickavalueinthemonthcolumnoftheSalesSummaryreporttoopenandrendertheSalesDetailsreport.Whatshouldyoudo？（）

MCTS(70-452)