单项选择题
You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements： ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use？（）
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. -
单项选择题
YoudesignaBusinessIntelligence（BI）solutionbyusingSQLServer2008.Youplantodesignthereportstrategyforanewreportprojectthatwillbeusedbyafinancialapplication.TheapplicationusesfivecalculationsthatareimplementedinMicrosoft.NETFramework3.5assemblies.TheassembliesarewrittenintheC#languageandusethestaticmethods.Youneedtoensurethatthecalculationscanbeusedbytheexpressionsinallreports.Youalsoneedtoensureconsistencywithinthereportsbyusingtheleastamountofdevelopmenteffort.Whatshouldyoudo？（）
A. Add a reference to the assemblies in the Report Properties References tab.
B. Write the calculation logic used by the calculations by using T-SQL functions.
C. Write the code of the calculation logic into the Report Properties Custom Code tab.
D. Write the calculation logic in each report by using the mathematical functions available natively to SQL Server 2008 Reporting Services （SSRS）.
