nerdexam
Microsoft

AZ-204 · Question #30

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…

The correct answer is B. Exclude the managers group. D. Run the following Azure PowerShell command. 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…

Submitted by mateo_ar· Mar 30, 2026Implement Azure security

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.

How the community answered

(22 responses)
  • A
    14% (3)
  • B
    73% (16)
  • C
    9% (2)
  • E
    5% (1)

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

Topics

#Azure SQL#dynamic data masking#data security#access control

Community Discussion

No community discussion yet for this question.

Full AZ-204 Practice