Designing and Implementing Cloud Data Platform Solutions — Question 1

You have a Microsoft Azure SQL database.
You need to ensure that you can use the Always Encrypted feature for the database.
Which two components should you configure? Each correct answer presents part of the solution.

Answer options

• A. the Column Master Key
• B. the database master key
• C. the service master key
• D. transparent data encryption (TDE)
• E. the Column Encryption Key

Correct answer: A

Explanation

The correct answers involve the Column Master Key and the Column Encryption Key, as both are essential components for implementing Always Encrypted. The database master key and service master key are not required for this specific feature, and transparent data encryption (TDE) serves a different purpose, focusing on encrypting data at rest.