exam questions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam

Exam 70-764 topic 1 question 156 discussion

Actual exam question from Microsoft's 70-764
Question #: 156
Topic #: 1
[All 70-764 Questions]

DRAG DROP -
You plan to deploy SQL Server 2014.
You identify the following security requirements for the deployment:
✑ Users must be prevented from intercepting and reading the T-SQL statements sent from the clients to the database engine.
✑ All database files and log files must be encrypted if the files are moved to another disk on another server.
You need to identify which feature meets each security requirement. The solution must minimize processor overhead.
Which features should you identify? To answer, drag the appropriate feature to the correct requirement in the answer area.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
- Secure Sockets Layer (SSL) encryption enables transmitting encrypted data across the network between an instance of SQL Server and a client application.
- Transparent data encryption (TDE) performs real-time I/O encryption and decryption of the data and log files.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Harvelino
4 years, 5 months ago
This is about the connection between the client and the database. So SSL is good.
upvoted 1 times
...
budbongo
4 years, 9 months ago
The exam ref book advises against using SSL. I'd have thought Always Encrypted or TLS would be better options in the answer list.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago