Which three components are required to meet the encryption requirements for the ListTest database? Each correct answer presents part of the solution.

Which three components are required to meet the encryption requirements for the ListTest database? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.
A . a Column Master Key
B . a certificate
C . an Always Encrypted enabled driver
D . a Column Encryption Key
E . a service master key
F . a database master key

View Answer

Answer: A,C,D

Explanation:

References: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/create-and-store­column-masterkeys-always-encrypted?view=sql-server-2017