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.