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?

You are developing a project that contains multipleSQL Server Integration Services (SSIS) packages. The
packages will be deployed to the SSIS catalog. One of the steps in each package accesses an FTP site to
download sales transaction data. You create projectparameters to store the username and password thatare
used to access the FTP site. You need to ensure that the username and password values are encrypted when
they are deployed. What should you do?

You are editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL tasksand
no other tasks. The package and all three Execute SQL tasks have their TransactionOption property set to
Supported. You need to ensure that if any of the Execute SQL tasks fail, all three tasks will roll back their
changes. What should you do?

You are designing a SQL Server Integration Services(SSIS) package that uploads a file to a table named
Orders in a SQL Azure database. The company’s auditing policies have the following requirements:
An entry must be written to a dedicated SQL Server log table named OrderLog.
The entry must be written as soon as the file upload task completes.
You need to meet the company’s policy requirements.Which event handler should you use?

You are designing a data warehouse with two fact tables. The first table contains sales per month and the
second table contains orders per day. Referential integrity must be enforced declaratively. You need to design a
solution that can join a single time dimension to both fact tables. What should you do?

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services
(DQS). You need to complete the post-installation configuration. What should you do?

You are completing the installation of the Data Quality Server component of SQL Server Data Quality Services
(DQS). You need to complete the post-installation configuration. What should you do?