Microsoft
DP-300 · Question #276
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…
The correct answer is A. Column1 E. Column5. Always Encrypted isn't supported for the columns using one of the following data types: xml, timestamp, rowversion, image, ntext, text, sql_variant, hierarchyid, geography, geometry, alias, user-defined types.
Submitted by olafpl· Mar 6, 2026Implement a secure environment
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.
Options
- AColumn1
- BColumn2
- CColumn3
- DColumn4
- EColumn5
How the community answered
(24 responses)- A75% (18)
- B8% (2)
- C13% (3)
- D4% (1)
Explanation
Always Encrypted isn't supported for the columns using one of the following data types: xml, timestamp, rowversion, image, ntext, text, sql_variant, hierarchyid, geography, geometry, alias, user-defined types.
Topics
#Always Encrypted#column data types#encryption support#Azure SQL Database
Community Discussion
No community discussion yet for this question.