单项选择题
You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution by using SQL Server 2008. Several reports on the server use a shared data source named DSProduction. You modify an existing report that uses the DSProduction data source. After deployment, the modified report must use an alternate data source. You need to prevent the modified report from affecting other reports. What should you do?()
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. -
单项选择题
YoudesignaBusinessIntelligence(BI)solutionbyusingSQLServer2008.YoucreateaSQLServer2008ReportingServices(SSRS)solution.YoucreatereportsbyusingMicrosoftVisualStudio.NET2008.Thedevelopmentteamofyourcompanymustcreate50SSRSreports.Youneedtoensurethatthecompanylogoandthecompanynameareincludedinthepageheaderofallthereports.Whatshouldyoudo?()
A. Create an SSRS report and include the required page header in the report. Use the report as a template for all the reports.
B. Create an SSRS report and include the required page header in the report. Create a subreport that refers to the report. Include the subreport to all the reports.
C. Create a SSRS report and include the required page header in the report. Copy the report definition to an XML file.Add the XML file as a data source for all the reports.
D. Create a SSRS report and include the required page header in the report. Create a class library that includes the report.Add the class library as an assembly reference for all the reports.
