DP-300 Certification Practice Question #69

Question

You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1.
You need to protect the contents of Column1 at rest, in transit, and in use.
How should you protect the contents of Column1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

To protect the data in `Column1` at rest, in transit, and in use, Always Encrypted must be used, which utilizes a Column encryption key. Furthermore, because `Column1` is used for joins by the application, the database engine must be able to perform equality comparisons on the encrypted values. In standard Always Encrypted, this requires using the Deterministic encryption type, as Randomized encryption does not support equality comparisons or joins.

More DP-300 practice questions