70-450 · Question #25
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…
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…
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
How the community answered
(52 responses)- A69% (36)
- B4% (2)
- C8% (4)
- D19% (10)
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
Topics
Community Discussion
No community discussion yet for this question.