nerdexam
MicrosoftMicrosoft

DP-300 · Question #107

DP-300 Question #107: Real Exam Question with Answer & Explanation

The correct answer is D: 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-

Submitted by jaden.t· Mar 6, 2026Implement a secure environment

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

  • Arow-level security
  • Bdata masking
  • CAlways Encrypted
  • Dcolumn-level security

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-

Community Discussion

No community discussion yet for this question.

Full DP-300 PracticeBrowse All DP-300 Questions