单项选择题
You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. You create reports by using Microsoft Visual Studio .NET 2008. The development team of your company must create 50 SSRS reports. You need to ensure that the company logo and the company name are included in the page header of all the reports. What should you do？（）
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）. -
单项选择题
YoudesignaBusinessIntelligence（BI）solutionbyusingSQLServer2008.ASQLServer2008AnalysisServices（SSAS）solutioncontainsacubethathasthefollowingobjects：·DimensionsnamedDimCustomer，DimProduct，andDimGeography·MeasuresnamedInternetSalesandTotalSalesUsersrunreportsagainstalldimensionsandmeasuresbyauthenticatingwiththeirWindowsaccounts.YouneedtoprovideabasicviewofdatatotheuserstodisplayonlyDimGeography，DimProduct，and TotalSalesbyusingtheleastamountofstoragespace.Whatshouldyoudo？（）
A. Create a new perspective for the current cube. Select DimGeography， DimProduct， and TotalSales.
B. Create a new cube. Add DimGeography， DimProduct， and TotalSales.
C. Create a new role. Grant access only to DimGeography， DimProduct， and TotalSales.
D. Create a new data source view. Add the tables used for DimGeography， DimProduct， and TotalSales. -
单项选择题
YoudesignaBusinessIntelligence（BI）solutionbyusingSQLServer2008.YoucreateaSQLServer2008IntegrationServices（SSIS）packagetoperformanextract，transform，andload（ETL）processtoloaddatatoaDimCustomerdimensiontablethatcontains1millionrows.Yourdataflowusesthefollowingcomponents：ASQLDestinationdataflowtasktoinsertnewcustomersAnOLEDBCommandtransformthatupdatesexistingcustomersOnaverage，25percentofexistingcustomerrecordsisupdatedeachnight.Youneedtoreducetheamountoftimerequiredtoupdatecustomerrecords.Whatshouldyoudo？（）
A. Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint.
B. Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint.
C. Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
D. Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.
