Exam 70-764 topic 1 question 239 discussion

Actual exam question from Microsoft's 70-764

Question #: 239
Topic #: 1

You work as a Database Administrator (DBA) at 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 to host databases used by 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 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)

Show Suggested Answer

Suggested Answer: B 🗳️

by Slava_bcd81 at Sept. 14, 2020, 7:59 a.m.

Comments

Submit Cancel

Slava_bcd81

4 years, 7 months ago

"deploy a SQL Server 2012 server to host databases used to host databases " - sounds like new encryption method

upvoted 1 times

Harvelino

4 years, 4 months ago

Let put a comma: to host databases used to host databases, used by Research and Development department

upvoted 1 times

...

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam

Exam 70-764 topic 1 question 239 discussion

Comments

Slava_bcd81

Harvelino

SY0-701