You are developing a SQL Server Integration Services (SSIS) project to read and write data
from a Windows Azure SQL Database database to a server that runs SQL Server 2012.
The connection will be used by data flow tasks in multiple SSIS packages. The address of
the target Windows Azure SQL Database database will be provided by a project parameter.
You need to create a solution to meet the requirements by using the least amount of
administrative effort and maximizing data flow performance.
What should you do?
A.
Use an SSIS Script task that uses the custom assembly to parse the text data when
inserting it.
B.
Use an SSIS Script transformation that uses the custom assembly to parse the text data
when inserting it.
C.
Create a SQL Common Language Runtime (SQLCLR) function that uses the custom
assembly to parse the text data, deploy it in the Windows Azure SQL Database database,
and use it when inserting data.
D.
Create a SQL Common Language Runtime (SQLCLR) stored procedure that uses the
custom assembly to parse the text data, deploy it in the Windows Azure SQL Database
database, and use it when inserting data.
Can’t this be achieved by a Script task? Why to use the script task as transformation?
I was thinking the same thing!
A
are the responses to most of the questions here are properly verified? most of the answers give seems to be wrong. Did anyone take the test recently?
Funny I was looking for the question that these were the answers to. Here are the real answers for this:
hhttp://www.aiotestking.com/microsoft/you-need-to-create-a-solution-to-meet-the-requirements-by-using-the-least-amount-of-administrative-effort-and-maximizing-data-flow-performance-2/#comment-742819