Exam AZ-500 All Questions

View all questions & answers for the AZ-500 exam

Exam AZ-500 topic 5 question 20 discussion

Actual exam question from Microsoft's AZ-500

Question #: 20
Topic #: 5

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

Suggested Answer: CE 🗳️

by AS007 at April 21, 2020, 3:32 a.m.

Comments

Submit Cancel

AS007

Highly Voted 5 years, 2 months ago

Correct ones

upvoted 21 times

...

gfhbox0083

Highly Voted 5 years ago

C, E, for sure.

upvoted 13 times

...

saira23

Most Recent 11 months, 2 weeks ago

In Exam20/07/2024

upvoted 1 times

...

Ivan80

1 year, 5 months ago

In exam 1/28/24

upvoted 2 times

...

ITFranz

1 year, 8 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, 10 months ago

Selected Answer: CE

C. the column encryption key E. the column master key

upvoted 3 times

...

Self_Study

1 year, 11 months ago

On an exam on 7/8/23, agree with the answer provided.

upvoted 1 times

...

majstor86

2 years, 4 months ago

Selected Answer: CE

C. the column encryption key E. the column master key

upvoted 4 times

...

qerem

2 years, 5 months ago

Selected Answer: CE

C, E, for sure.

upvoted 1 times

...

somenick

2 years, 8 months ago

Selected Answer: CE

Duplicate

upvoted 1 times

...

cyberexpert23

3 years ago

In exam: 30/06/2022

upvoted 2 times

...

WhalerTom

3 years, 6 months ago

In exam Dec'21. 40 questions, 1 case study, no labs. Correct answer too.

upvoted 2 times

...

zioggs

3 years, 8 months ago

Exam - 4/11/21

upvoted 1 times

...

itbrpl

3 years, 8 months ago

Today's exam 20/10/21..

upvoted 1 times

...

poplovic

3 years, 10 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, 11 months ago

In Exam 8/4/2021

upvoted 4 times

...

dfernandes

3 years, 11 months ago

also in AZ-301/304 exam

upvoted 4 times

...

Load full discussion...