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?
A.
Create a SQL Common Language Runtime (SQLCLR) function that uses the custom assembly to
encrypt the data, deploy it in the Windows Azure SQL Database database, and use it when inserting
data.
B.
Use an SSIS Script transformation that uses the custom assembly to encrypt the data when inserting
it.
C.
Create a SQL Common Language Runtime (SQLCLR) stored procedure that uses the custom assembly
to encrypt the data, deploy it in the Windows Azure SQL Database database, and use it when inserting
data.
D.
Use an SSIS Script task that uses the custom assembly to encrypt the data when inserting it.
D.?
I don’t think the question is about control flow task.
I think it’s about a dataflow component, so SSIS Script transformation component fits here better.
Control flow manages your package’s workflow, or how the package organizes the ETL operation. Data flow, for the most part, performs the actual ETL operations that move and modify data. To extend data flow, you can use the Script component, which is the data-flow counterpart to the Script task.
so it is B. SSIS Script transformation