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 web site. 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 usernames, passwords and credit card details are securely stored
in the database.
Which of the following would be most suitable secure storage solution?
A.
Secure Sockets Layer (SSL)
B.
IPSec
C.
Data encryption
D.
Transparent Data Encryption (TDE)
E.
Encrypting File System (EFS)
Explanation:
D, as the question asked “You need to ensure the usernames, passwords and credit card details are securely stored in the database.”