DP-203 · Question #32
You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to recommend a solution…
The correct answer is C. column-level security. Column-level security simplifies the design and coding of security in your application, allowing you to restrict column access to protect sensitive data. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-
Question
You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information. What should you include in the recommendation?
Options
- Adata masking
- BAlways Encrypted
- Ccolumn-level security
- Drow-level security
How the community answered
(21 responses)- A5% (1)
- B5% (1)
- C76% (16)
- D14% (3)
Explanation
Column-level security simplifies the design and coding of security in your application, allowing you to restrict column access to protect sensitive data. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-
Topics
Community Discussion
No community discussion yet for this question.