Administering a SQL Database Infrastructure — Question 166

You work as a Database Administrator (DBA) for a company named ABC.com.
The company has a Windows Azure subscription.
The company uses a cloud based SQL Server environment hosted on SQL Azure.
Developers in your company are creating an ecommerce website.
You are designing a database for the website.
The database will be hosted on SQL Azure.
The database will store and reuse web site login details and customer credit card numbers.
You need to ensure the username, passwords and credit card details are securely stored in the database.
Which of the following would be the most suitable secure storage solution?

Answer options

• A. Secure Sockets Layer (SSL)
• B. IPSec
• C. Data encryption
• D. Transparent Data Encryption (TDE)
• E. Encrypting File System (EFS)

Correct answer: C

Explanation

The correct answer is C, Data encryption, because it provides a method to securely encode sensitive data like usernames, passwords, and credit card information, making it unreadable to unauthorized users. Options A, B, D, and E serve different purposes; SSL and IPSec focus on secure transmission, while TDE and EFS are more about encrypting data at rest or protecting files, but do not directly address the specific needs of securely storing sensitive data within a database.