YOU NEED TO STORE SENSITIVE DATA IN YOUR SQL SERVER DATABASE. THE...

15. You need to store sensitive data in your SQL Server database. The application

has already been written and works fine. What’s the easiest way to do this

without having to change your application?

A. Modify the stored procedures to use xp_encryptstring

B. Use transparent data encryption

C. Use a third-party tool

D. Use a trigger

The correct answer is B. Transparent data encryption enables data to be

stored securely by encrypting the database files. Answer A is incorrect, as this

is not the best approach. Answer C is incorrect; while there are third-party

encryption tools, this is not the best approach. Answer D is incorrect; triggers

by themselves are not a correct solution.