You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions,
the package execution does not finish and no data seems to have been transferred. You need to ensure that
package logging occurs. Your solution must minimizedeployment and development efforts. What should you
do?

To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging methodology is
put in place. The methodology has the following requirements:
The deployment process must be simplified.
All the logs must be centralized in SQL Server.
Log data must be available via reports or T-SQL.
Log archival must be automated.
You need to configure a logging methodology that meets the requirements while minimizing the amount of
deployment and development effort. What should you do?

To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS) package
logging methodology. The methodology has the following requirements:
Centralized logging in SQL Server
Simple deployment
Availability of log information through reports or T-SQL
Automatic purge of older log entries
Configurable log details
You need to configure a logging methodology that meets the requirements while minimizing the amount of
deployment and development effort. What should you do?

You are deploying a new SQL Server Integration Services (SSIS) project to the test environment. A package in
the project uses a custom task component. You need to ensure that the custom object is deployed on thetest
environment correctly. What should you do?

You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy system.
Data integrity in the legacy system is very poor. Invalid rows are discarded by the package but must be logged
to a CSV file for auditing purposes. You need to establish the best technique to log these invalid rows while
minimizing the amount of development effort. What should you do?

You are deploying a project to the SQL Server Integration Services (SSIS) catalog. You need to ensure that the
project is deployed to the production environment with the least amount of administrative effort. Whatshould
you do?

Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not
complete and nothing is processed. You need to ensure that package logging occurs. Your solution must
minimize deployment and development efforts. What should you do?

You are adding a new capability to several dozen SQL Server Integration Services (SSIS) packages. The new
capability is not available as an SSIS task. Each package must be extended with the same new capability. You
need to add the new capability to all the packages without copying the code between packages. What should
you do?

You are the data steward for a Business Intelligence project. You must identify duplicate rows stored in a SQL
Server table and output discoveries to a CSV file. A Data Quality Services (DQS) knowledge base has been
created to support this project. You need to produce the CSV file with the least amount of developmenteffort.
What should you do?

You are designing a data warehouse hosted on SQL Azure. The data warehouse currently includes the
dimUser and dimDistrict dimension tables and the factSales fact table. The dimUser table contains records for
each user permitted to run reports against the warehouse, and the dimDistrict table contains information about
sales districts. The system is accessed by users from certain districts, as well as by area supervisors and users
from the corporate headquarters. You need to designa table structure to ensure that certain users cansee
sales data for only certain districts. Some users must be permitted to see sales data from multiple districts.
What should you do?