You work as a Systems Administrator at a company named ABC.com. You are in the
process of deploying new servers running SQL Server 2012.
You need to deploy a SQL Server 2012 server to host databases used by the Research and
Development department. The databases used by the Research and Development
department will store sensitive data.
A company security policy states that if Research and Development department database
files and log files are moved to another server, the files must be encrypted.
Which of the following solutions would meet the encryption requirement?
A.
Encrypting File System (EFS)
B.
Transparent Data Encryption (TDE)
C.
Windows BitLocker Drive Encryption.
D.
Secure Sockets Layer (SSL)
Explanation:
http://msdn.microsoft.com/en-GB/library/bb934049.aspx
Answer is B
B
I think B, too
A – never heard of
B – encrypts data, not files
D – SSL doesn’t even make sense
should be B. with C, the file could not be moved to another server
The Encrypting File System would encrypt the file in the current hard drive, because its partition would be encrypted, but once copied to another place wouldn’t be encrypted (Note: I also think it would cause errors on SQL Server), so it isn’t the answer.
The Windows BitLocker Drive Encryption protects files in the current location encrypting the files, but in order to copy it to another place it should be decrypted or the other computer wouldn’t understand the file (Note: I also think it would cause errors on SQL Server), so it isn’t the answer.
The Secure Sockets Layer it a communication security, doesn’t make any sense with the question, so it isn’t the answer.
The Transparent Data Encryption it’s a SQL Serve feature that can be used to encrypt field, tables and the whole database, so that is the CORRECT answer.