Câu 50: 70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 20122014

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 Microsoft Azure SQL 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?

1. A. Use an SSIS Script transformation that uses the custom assembly to encrypt the data when inserting it. — đáp án hiện tại
2. B. Use an SSIS Script task that uses the custom assembly the encrypt the data when inserting it.
3. C. Create a SQL Common Language Runtime (SQLCLR) stored procedure that uses the custom assembly to encrypt the data, deploy it in the Microsoft Azure SQL Database and use it when inserting data.
4. D. Create a SQL Common Language Runtime (SQLCLR) function that uses the custom assembly to encrypt the data, deploy it in the Microsoft Azure SQL