Free Microsoft 070-452 Exam Dumps Questions & Answers

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. And you develop a SQL Server 2008 Reporting Services (SSRS) solution. You use Microsoft Visual Studio .NET 2008 to create reports. The manager of your company asks to create 60 SSRS reports. You mustmake sure that the company logo and the company name are included in the page header of all the reports. So what should you do?

• A.  You should create a SSRS report and include the required page header in the report. Create a class library that includes the report and add the class library as an
• B.  You should create an SSRS report and include the required page header in the report and create a subreport that refers to the report. Include the subreport to all
• C.  You should create a SSRS report and include the required page header in the report. Copy the report definition to an XML file and add the XML file as a data
• D.  You should create an SSRS report and include the required page header in the report. And use the report as a template for all the reports.

You are the administrator of your company network. You use SQL Server 2008 to develop a Business Intelligence (BI) solution. And you work out a SQL Server 2008 Reporting Services (SSRS) solution. There??s a report named Sales Details in the solution. The report shows the total weekly sales of each employee. Users may view theSales Summary report, they may need the weekly sales details for certain employee. In order to make sure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report, you have to do something. So what should you do?

• A.  You should use a drillthrough report link.
• B.  You should use the drilldown functionality.
• C.  You should use a bookmark link.
• D.  You should use a subreport.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to transform sales data from a retail sales outlet database to a SQL Server 2008 data warehouse by using SQL Server 2008 Integration Services (SSIS). The retail sales database is an online transaction processing (OLTP) database that processes large amounts of transactions twenty-four hours a day. You need to design the structure of the SSIS packages such that the performance of the source system is minimally affected. What should you do?

• A.  Load and transform data from the source directly to the data warehouse four times a day at regular intervals of time.
• B.  Load data from the source to a staging database once a day. Then, transform the data to the data warehouse.
• C.  Load data from the source to a staging database four times a day at regular intervals of time. Then, transform the data to the data warehouse once a day.
• D.  Load and transform data from the source directly to the data warehouse once a day.

You are designing a SQL Server 2008 Reporting Services (SSRS) solution. You have a report that has
several parameters that are populated when users execute the report. You need to ensure that the solution
meets the following requirements:
-Users can define their own default parameter values for the report.
-Users can schedule snapshots at any time.
Which feature should you use?

• A.  My Reports
• B.  Linked Reports
• C.  Standard Subscription
• D.  Data-Driven Subscription

You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Reporting Services (SSRS) instance contains a report. Employees execute the report by using Report Manager. Each employee has his own specific set of parameters to execute the report. Data for the report is updated once daily. For each employee, the report takes more than five minutes to execute. You discover that data retrieval takes most of the time during report execution. You need to reduce the execution time of the report. What should you do?

• A.  Create a standard subscription that uses the file share delivery method.
• B.  Create a report execution snapshot.
• C.  Create a data-driven subscription that uses the NULL delivery method.
• D.  Create a data-driven subscription that uses the file share delivery method.