You need to configure the Fuzzy Lookup transformation in the most efficient manner
You are designing a SQL Server Integration Services (SSIS) package that uses the Fuzzy
Lookup transformation.
The reference data to be used in the transformation changes with every package execution.
Common language runtime (CLR) integration cannot be enabled on the SQL Server
database where the reference table is located.
You need to configure the Fuzzy Lookup transformation in the most efficient manner.
What should you do?
Which data flow transformation should you use?
You are developing a SQL Server Integration Services (SSIS) package to implement an
incremental data load strategy. The package reads data from a source system that uses the
SQL Server change data capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the
source system.
You need to add a data flow transformation to redirect rows for separate processing of
insert, update, and delete operations.
Which data flow transformation should you use?
You need to run an update statement against the table
You are designing a data warehouse that uses SQL Server 2012. You are preparing to
update the contents of a fact table that contains a non-clustered columnstore index.
You need to run an update statement against the table.
What should you do first?
You need to define and reuse the Excel file connection in all project packages
You are using SQL Server Data Tools to develop a SQL Server Integration Services (SSIS)
project.
The first package that you create in this project contains a package connection that
accesses a Microsoft Excel file. Additional packages in the project must also access this file.
You need to define and reuse the Excel file connection in all project packages.
What should you do?
Which Data Flow transformation should you use?
You are designing a SQL Server Integration Services (SSIS) data flow to load sales
transactions from a source system into a data warehouse hosted on Windows Azure SQL
Database. One of the columns in the data source is named ProductCode.
Some of the data to be loaded will reference products that need special processing logic in
the data flow.
You need to enable separate processing streams for a subset of rows based on the source
product code.
Which Data Flow transformation should you use?
You need to design the implementation strategy to meet the requirements while minimizing development and deplo
Your company uses a proprietary encryption algorithm to secure sensitive data. A custom
cryptographic assembly was developed in Microsoft .NET and is used in several
applications.
A SQL Server Integration Services (SSIS) package is importing data into a Windows Azure
SQL Database database. Some of the data must be encrypted with the proprietary
encryption algorithm.
You need to design the implementation strategy to meet the requirements while minimizing
development and deployment effort and maximizing data flow performance.
What should you do?
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company.
You need to ensure that an OLTP database that includes up-to-the-minute reporting requirements
can be off-loaded from the primary database to another server. You also need to be able to add
indexes to the secondary database.
Which configuration should you use?
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company.
You need to ensure that data changes are sent to a non-SQL Server database server in near real
time.
You also need to ensure that data on the primary server is unaffected.
Which configuration should you use?
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company.
A database contains a large product catalog that is updated periodically.
You need to be able to send the entire product catalog to all branch offices on a monthly basis.
Which configuration should you use?
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company.
You need to ensure that an OLTP database that uses a storage area network (SAN) remains available
if any of the servers fail.
You also need to minimize the amount of storage used by the database.
Which configuration should you use?