Microsoft PRO:MS SQL Server 2008, Designing a Business Intelligence : 070-452 Exam Questions

You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution will contain a total
of 100 different reports created by using Report Definition Language (RDL).
Each report must meet the following requirements:
-Display a common set of calculations based on a parameter value.
-Provide a method for setting values on a report URL or in a subscription definition that are not exposed to a
user.
-The business rules for all reports that determine the calculations change frequently.
You need to design a solution that meets the requirements. You need to perform this action by using the
minimum amount of development and maintenance effort.
What should you do?

• A. Create internal parameters in each report.
• B. Create hidden parameters in each report.
• C. Implement the function in a custom assembly. Reference the assembly in each report.
• D. Implement the function in the <Code> element of each report.

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 an SSRS report and include the required page header in the report. And use the report as a template for all the reports.
• 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 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

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008
Reporting Services (SSRS) solution. The solution has a report named SalesDetails that contains a
parameter named EmployeeID .
You have the following constraints:
-Ten thousand employees require the report in different file formats.
-The employees can view only their sales data by specifying their identity number as the EmployeeID
parameter.
You need to ensure that the constraints are met before you deliver the report to the employees. What
should you do?

• A. Create a data-driven subscription.
• B. Create a report model for each employee.
• C. Create a SharePoint Report Center site.
• D. Create a subscription for each employee.

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008
Integration Services (SSIS) package to perform an extract, transform, and load (ETL) process to load data
to a DimCustomer dimension table that contains 1 million rows.
Your data flow uses the following components:
-A SQL Destination data flow task to insert new customers.
-An OLE DB Command transform that updates existing customers.
On average, 25 percent of existing customer records is updated each night. You need to reduce the
amount of time required to update customer records.
What should you do?

• A. 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.
• B. Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint.
• C. Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint.
• D. 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.

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. Data-Driven Subscription
• B. Standard Subscription
• C. Linked Reports
• D. My Reports