ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-765 All Questions

View all questions & answers for the 70-765 exam
Go to Exam

Exam 70-765 topic 2 question 5 discussion

Actual exam question from Microsoft's 70-765
Question #: 5
Topic #: 2
[All 70-765 Questions]

You manage a Microsoft SQL Server environment in a Microsoft Azure virtual machine.
You must enable Always Encrypted for columns in a database.
You need to configure the key store provider.
What should you do?

  • A. Manually specify the column master key.
  • B. Modify the connection string for applications.
  • C. Auto-generate a column master key.
  • D. Use the Windows certificate store.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Always Encrypted supports multiple key stores for storing Always Encrypted column master keys. A column master key can be a certificate stored in Windows
Certificate Store.
References:
https://msdn.microsoft.com/en-us/library/mt723359.aspx
by jolsca at Sept. 7, 2020, 4:13 p.m.

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
Submit Cancel
jolsca
4 years, 10 months ago
Is correct: Always Encrypted can use external trusted key stores such as Azure Key Value, Windows Certifcate Store on a client machine, or a thirdparty hardware security module.
upvoted 2 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