Incorrect: The UNIQUE constraint enforces the uniqueness of the values in a set of columns. It does not ensure that column data meets specific entry requirements.

Incorrect: The UPDATE statement changes existing data in a table or view. It does not ensure that column data meets specific entry requirements.

Incorrect: The HAVING clause, typically used with a GROUP BY statement, determines the output of a SQL Server 2005 query. It does not ensure that column data meets specific entry requirements.

Correct: You can use the CHECK constraint to ensure that column data entered from any source meets the requirements of the written company policy.

Incorrect: Typically, you use SSMS for managing databases rather than for transforming data.

Incorrect: Typically, you use BIDS for database development rather than for transforming data.

Correct: You use SSIS for extracting, transforming, and loading data.

Incorrect: Typically, you use SSRS for ad hoc and managed reporting rather than for transforming data.

Correct: The SSIS deployment utility can deploy multiple packages, including the package dependencies (for example, configurations and table names). The manifest file lists the packages, the package configurations, and any miscellaneous files in the project.

Incorrect: The UNION statement combines the results of two or more queries into a single result set. It cannot combine data from tables that use different table names.

Incorrect: Backup and restore is not the recommended mechanism for deploying SSIS packages in a production environment. You cannot use the msdb database to merge data from tables that have different table names.

Incorrect: The ALTER TABLE Transact-SQL statement cannot alter table names.

Incorrect: The Fuzzy Grouping transformation, not the Fuzzy Lookup transformation, identifies rows of data that are likely to be duplicates and selects a row of data (known as the canonical row) that it uses to standardize the data.

Correct: The Fuzzy Lookup transformation provides a default set of delimiters used to tokenize the data. Tokenization is important because it defines the units within the data that are compared to each other.

Correct: The Fuzzy Lookup transformation specifies the maximum number of matches to return per input row.

Correct: The Fuzzy Lookup transformation uses similarity thresholds to derive similarity and confidence scores. Similarity thresholds can be set at the component and join levels.

Incorrect: The manifest file lists the packages, the package configurations, and any miscellaneous files in the project. It does not contain timing information.

Incorrect: The SSIS package has been working fine and suddenly it takes a long time to run. You want to find out why. Redeploying the packet could reduce the run time (but probably will not). It does not give you any indication of why the problem occurred.

Correct: The counters associated with the SQL Server:SSIS Pipeline performance object can determine whether any memory issues affect the performance of SSIS packages.

Incorrect: Profiler can create traces that specify event classes in the Security Audit Event Category to help you to verify that users with the appropriate permissions are observing database change control procedures. This does not affect memory issues related to running SSIS packages.