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.