Microsoft
70-463 · Question #239
70-463 Question #239: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #239. The question stem and answer options stay visible for context.
Question
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?
Options
- ACreate a SQL Common Language Runtime (SQLCLR) function that uses the custom
- BUse an SSIS Script transformation that uses the custom assembly to encrypt the data when
- CCreate a SQL Common Language Runtime (SQLCLR) stored procedure that uses the custom
- DUse an SSIS Script task that uses the custom assembly to encrypt the data when inserting it.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.