Microsoft
70-450 · Question #25
70-450 Question #25: Real Exam Question with Answer & Explanation
The correct answer is A. Symmetric key encryption. Symmetric key encryption is the most commonly recommended option for SQL Server 2008 It provides security without overly taxing the server like asymmetric encryption might. Certificates have a similar architecture (public-private key). TDE is not appropriate, as it would encrypt
Question
You administer a SQL Server 2008 instance. The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data. You need to store the sensitive data in the most secure manner possible. You also need to ensure that you minimize the usage of memory space and processor time. Which encryption type should you use?
Options
- ASymmetric key encryption
- BAsymmetric key encryption
- CCertificate-based encryption
- DTransparent data encryption
Explanation
Symmetric key encryption is the most commonly recommended option for SQL Server 2008 It provides security without overly taxing the server like asymmetric encryption might. Certificates have a similar architecture (public-private key). TDE is not appropriate, as it would encrypt the entire database. yEncryptionTutorial.aspx
Community Discussion
No community discussion yet for this question.