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?