nerdexam
MicrosoftMicrosoft

AZ-204 · Question #30

AZ-204 Question #30: Real Exam Question with Answer & Explanation

The correct answer is B: Exclude the managers group.. Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer. SQL users excluded from masking - A set of SQL users or AAD identities that get unmas

Submitted by mateo_ar· Mar 30, 2026

Question

A company uses Azure SQL Database to store data for an app. The data includes sensitive information. You need to implement measures that allow only members of the managers group to see sensitive information. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

  • ANavigate to the following URL:
  • BExclude the managers group.
  • CInclude the managers group.
  • DRun the following Azure PowerShell command:
  • EExclude the administrators group.

Explanation

Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer. SQL users excluded from masking - A set of SQL users or AAD identities that get unmasked data in the SQL query results. Note: The New-AzureRmSqlDatabaseDataMaskingRule cmdlet creates a data masking rule for an Azure SQL database. https://docs.microsoft.com/en-us/powershell/module/azurerm.sql/new- azurermsqldatabasedatamaskingrule?view=azurermps-6.13.0

Community Discussion

No community discussion yet for this question.

Full AZ-204 PracticeBrowse All AZ-204 Questions