ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 32 - AZ-500 discussion

Report
Export

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
Answers
A.
a stored access policy
B.
a shared access signature (SAS)
Answers
B.
a shared access signature (SAS)
C.
the column encryption key
Answers
C.
the column encryption key
D.
user credentials
Answers
D.
user credentials
E.
the column master key
Answers
E.
the column master key
Suggested answer: C, E

Explanation:

Always Encrypted uses two types of keys: column encryption keys and 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.

References: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine

asked 02/10/2024
Jordan Fredriksz
33 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first