DP-300 Certification Practice Question #98

Question

You have an Azure SQL database named DB1. DB1 has a table named Table1 that contains the following columns.

You plan to enable Always Encrypted for Table1.

Which two columns support encryption? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Accepted Answer

The unsupported types for Always Encrypted include ntext (Column1), geometry (Column2), and image (Column3). Varchar (Column4) and Datetime2 (Column5) are both fully supported. Despite the suggested answer only listing E, 25 community votes confirm D and E. Datetime2 is NOT the same as the `timestamp`/`rowversion` type in SQL Server (which is a binary auto-incrementing counter) and IS supported.

More DP-300 practice questions