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 3 question 90 discussion

Actual exam question from Microsoft's 70-765
Question #: 90
Topic #: 3
[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. Use the Randomized encryption type
  • B. Modify the connection string for applications.
  • C. Auto-generate a column master key.
  • D. Use the Azure Key Vault.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Expalantion:
There are two high-level categories of key stores to consider - Local Key Stores, and Centralized Key Stores.
✑ Centralized Key Stores - serve applications on multiple computers. An example of a centralized key store is Azure Key Vault.
✑ Local Key Stores
References: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/create-and-store-column-master-keys-always-encrypted
by jolsca at Sept. 8, 2020, 11:42 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, 9 months ago
Is Correct: D For select the key store provider exists: - Windows certificate store - Azure Key Vault
upvoted 3 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