You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse.

You need to establish the correct order for loading each table to maximize parallel processing. Which
order should you use?

You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data
warehouse every night. The SQL Azure data contains many misspellings and variations of
abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the
closest-matching string from a reference table of allowed values. The number of rows in the
reference table is very large. If no acceptable match is found, the Fuzzy Lookup transformation
passes a null value. The current setting for the Fuzzy Lookup similarity threshold is 0.50. Many values
are incorrectly matched. You need to ensure that more accurate matches are made by the Fuzzy
Lookup transformation without degrading performance. What should 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?

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?

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 the test environment correctly. 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. 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 migrating a database named Orders to a new server that runs Microsoft SQL Server 2012.
You attempt to add a SQL login, [User1], to the database. However, you receive the following error
message:
“User already exists in current database.”
You need to configure the [User1] login to be able to access the Orders database and retain the
original permissions. You need to achieve this goal by using the minimum required permissions.
Which Transact-SQL statement should you use?

You administer a Microsoft SQL Server 2012 database. You create an availability group named
haContosoDbs. Your primary replica is available at Server01\Contoso01. You need to configure the
availability group to minimize transaction latency on any available secondary databases. In the event
of a database failure, the designated secondary database should come online automatically. Which
Transact-SQL statement should you use?

You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a
SQL Azure database into a data warehouse. The source system contains redundant or inconsistent
data. When the package finds invalid data, the row containing the invalid data must be omitted but
it must also be written to a text file for further analysis. You need to establish the best technique to
log these invalid rows while keeping the amount of development effort to a minimum. What should
you do?