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.
Bạn đang xem 15. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P141 DOC