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

Exam AZ-500 All Questions

View all questions & answers for the AZ-500 exam
Go to Exam

Exam AZ-500 topic 5 question 20 discussion

Actual exam question from Microsoft's AZ-500
Question #: 20
Topic #: 5
[All AZ-500 Questions]

You have an Azure SQL database.
You implement Always Encrypted.
You need to ensure that application developers can retrieve and decrypt data in the database.
Which two pieces of information should you provide to the developers? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. a stored access policy
  • B. a shared access signature (SAS)
  • C. the column encryption key
  • D. user credentials
  • E. the column master key
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️
by AS007 at April 21, 2020, 3:32 a.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
AS007
Highly Voted 5 years ago
Correct ones
upvoted 21 times
...
gfhbox0083
Highly Voted 4 years, 10 months ago
C, E, for sure.
upvoted 13 times
...
saira23
Most Recent 9 months, 3 weeks ago
In Exam20/07/2024
upvoted 1 times
...
Ivan80
1 year, 3 months ago
In exam 1/28/24
upvoted 2 times
...
ITFranz
1 year, 6 months ago
To set up Always Encrypted in your database, you need to: Provision cryptographic keys to protect your data. Always Encrypted uses two types of keys: Column encryption keys. Column master keys. A column encryption key is used to encrypt data in an encrypted column. A column master key is a key-protecting key that encrypts one or more column encryption keys. https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-ver16 Answer = C,E
upvoted 1 times
...
ESAJRR
1 year, 8 months ago
Selected Answer: CE
C. the column encryption key E. the column master key
upvoted 3 times
...
Self_Study
1 year, 9 months ago
On an exam on 7/8/23, agree with the answer provided.
upvoted 1 times
...
majstor86
2 years, 2 months ago
Selected Answer: CE
C. the column encryption key E. the column master key
upvoted 4 times
...
qerem
2 years, 3 months ago
Selected Answer: CE
C, E, for sure.
upvoted 1 times
...
somenick
2 years, 6 months ago
Selected Answer: CE
Duplicate
upvoted 1 times
...
cyberexpert23
2 years, 10 months ago
In exam: 30/06/2022
upvoted 2 times
...
WhalerTom
3 years, 4 months ago
In exam Dec'21. 40 questions, 1 case study, no labs. Correct answer too.
upvoted 2 times
...
zioggs
3 years, 6 months ago
Exam - 4/11/21
upvoted 1 times
...
itbrpl
3 years, 6 months ago
Today's exam 20/10/21..
upvoted 1 times
...
poplovic
3 years, 8 months ago
master key is stored in key vault or external key store. individual column key is protected by master key. Master key's information is needed and encrypted column key is needed. there fore the answer is c and e
upvoted 1 times
...
Sandomj55
3 years, 9 months ago
In Exam 8/4/2021
upvoted 4 times
...
dfernandes
3 years, 10 months ago
also in AZ-301/304 exam
upvoted 4 times
...
Load full discussion...
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago