You are using SQL Server 2008 Reporting Services to create reports for your company, an
automobile supply chain. You create a report called AutomotivePartsSales that displays the sales
for the last period. This report displays sales of over 500 different parts. The report is rendered in
PDF format.
Users complain that the page breaks are not set in the correct places when they print the report.
What report controls should you change to so that page breaks occur in the correct place when
users print? (Choose two.)

You are developing a SQL Server 2008 SQL Server Integration Services (SSIS) package. The
package consists of a Sequence container holding a For loop and a Foreach loop. There are two
Execute SQL tasks in the Foreach loop, and one Script task in the For loop.

You have created a variable for the Foreach loop. What will be the scope of the variable?

You are in the process of deploying an Analysis Services Database in the production environment.
You are using the Analysis Services Deployment Wizard to perform this deployment. The project
will be named Deploy_Prod1.
During the deployment process, you want to retain the existing roles and role members on the
destination server.
Which input file should you modify to accomplish the objective?

You are in the process of designing a cube named InvStock. The measure group in the cube will
have a measure named TotInventory that will be used to determine the total inventory stock for the
manufacturing department at the end of quarter.
What should you do to determine the inventory stock at the end of quarter?

You manage a Microsoft SQL Server Analysis Services (SSAS) database for your company.
Users are reporting that SSAS performance has recently degraded.
You run a SQL Profiler trace on MDX queries that are being executed on a SSAS instance. Trace
analysis shows that a MDX query executed by a new user is consuming more than the required
resources. You review the MDX query and identify that the MDX query contains a complex IIF
function to return a result set.
Which advice should you give to the new user to improve query performance?

You are the administrator for your company’s SQL Server 2008 server. You have created a
package using SQL Server Integration Services (SSIS) and have modified some of the package
properties. (Click the Exhibit(s) button to view the properties you configured.)
When you run the package for the first time, a file not found error occurs. When you rerun the
package, the package is successful. You want to ensure that you can restart the package at the
point of failure and skip any tasks in the package that have already completed. What should you
configure?

You are developing a SQL Server 2008 SSIS package. The package contains a Sequence
container, which in turn holds a Foreach Loop container and a For Loop container. The Foreach
Loop container updates all the records in a table named Salary of the Employee database using
an Execute SQL task. The For Loop container inserts five records in the Employee_details table of
the Employee database using an Execute SQL task. You need to ensure that if the transaction on
the Sequence task is aborted, the updates made in the Salary table are not rolled back, and the
updates made in the Employee_details table are rolled back.
What should you do? (Choose three.)

You want to deploy a custom assembly in SQL Server 2008 Report Services (SSRS) for use in the
reports you are generating for your organization. What must you do to deploy a custom assembly?

You create several reports for the ABC.com with SQL Server Report Services (SSRS) 2008. The
sales manager wants to look at the QtrSales report from last year to review sales figures from the
previous year. The QtrSales report has been modified several times and the data source has
changed.
How should you retrieve the information from last year’s QtrSales report using the least amount of
administrative effort?

You work as a Database Administrator for ABC.com. The company has a SQL Server 2008
computer. You manage SQL Server 2008 Reporting Services (SSRS) for the company, which has
a database named Production. You want to implement a database recovery operation for the
Production database. Which of the following utilities should you use to accomplish the task?