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 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?

You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. The
business model of the company uses SSIS. There are 30 packages that use the same
configuration and are stored in an XML file as a variable.
You want to track the changes that affect a package that uses one variable. You also want to
modify the package to provide automatic notification through email whenever there are changes to
the variable. What should you do?
Each correct answer represents a part of the solution. Choose all that apply.

[tagged]
You are an employee at ABC.com. The company has a SQL Server 2008 computer. The SQL
Server 2008 Reporting Services instance is being administered in the company. You want to view
the basic information about the report server. To which of the following roles should you be
assigned to accomplish the task?

[tagged]
You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. You
manage a SQL Server 2008 Integration Services (SSIS) package for the company. You want to
perform operations like mining text, cleaning data, and running data mining prediction queries.
Which of the following SQL Server Integration Services transformations should you choose to
accomplish the task?

[tagged]
You work as an administrator for ABC.com. The company has a SQL Server 2008 computer. You
are assigned a task to create and maintain Microsoft SQL Server 2008 Integration Services (SSIS)
packages with the help of SSIS Designer. While you were developing the packages, it failed.
Which of the following tabs of the SSIS Designer should you look to identify what happened?

You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. You
are designing a SQL Server 2008 Integration Services (SSIS) package. The package uses at least
one sequence container in one transaction. A Data Flow task and a Control Flow task are
controlled by each transaction. Each Data Flow task has a success constraint that is followed by
the Control Flow task. The following requirements should be included in the package:
Each Data Flow task must use its own transaction.
The Control Flow task and the Data Flow task that precedes it must fail or succeed as an atomic
unit.
A restart point must restart each Data Flow task and the Control Flow task that follows it as an
atomic unit.
You need to make changes in the control flow designer to meet the requirements. What should
you do?
Each correct answer represents a part of the solution. Choose all that apply.

You work as an administrator for ABC.com. The company has a SQL Server 2008 computer. You
manage a Microsoft SQL Server 2008 Analysis Services (SSAS) instance. You deploy a data
mining structure, which includes the Clustering mining model of Microsoft. You want to change the
mining model properties from Scalable K-Means to Non-scalable K-Means. Which of the following
parameters of the mining model should you change to accomplish the task?

You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. You
are creating a SQL Server 2008 Integration Services (SSIS) package. The package contains some
sensitive data that needs protection. In order to protect the package, you decide to encrypt the
entire package including the sensitive data. You provide a password to accomplish this. Which of
the following protection levels should you use?