单项选择题
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？（）
A. Update the connection string of the DSProduction shared data source to point to the alternate data source.
B. Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.
C. Create a new shared data source named DSProduction in the same folder as that of the modified report. Update the connection string of the new shared data source to point to the alternate data source.
D. Disable the DSProduction data source. Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source. -
单项选择题
YoudesignaBusinessIntelligence（BI）solutionbyusingSQLServer2008.YouplantocreateaSQLServer2008ReportingServices（SSRS）solution.Developersgeneraterandomreportsagainstadatasourcethatcontains200tables.Powerusersgeneraterandomreportsagainstfourofthe200tables.YouneedtodesignastrategyfortheSSRSsolutiontomeetthefollowingrequirements：·Usesminimumamountofdevelopmenteffort.·ProvidestwosetsoftablesinSSRStothedevelopersgroupandthepowerusersgroup.Whichstrategyshouldyouuse？（）
A. Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.
B. Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.
C. Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.
D. Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views. -
单项选择题
YoudesignaBusinessIntelligence（BI）solutionbyusingSQLServer2008.YoucreateaSQLServer2008ReportingServices（SSRS）solution.ThesolutioncontainsareportnamedSalesDetailsthatdisplayssalesinformationofalltheemployees.YoucreateanSSRSreportnamedSalesSummarythatdisplaysthetotalmonthlysalesofeachemployee.UserswhoviewtheSalesSummaryreportoccasionallyrequirethemonthlysalesdetailsforaparticularemployee.YouneedtoensurethattheuserscanclickavalueinthemonthcolumnoftheSalesSummaryreporttoopenandrendertheSalesDetailsreport.Whatshouldyoudo？（）
A. Use a subreport.
B. Use a bookmark link.
C. Use the drilldown functionality.
D. Use a drillthrough report link.
