Note: This question is part of a series of questions that present the same scenario.
Each question in the series contains a unique solution that might meet the stated goals.
Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it.
As a result, these questions will not appear in the review screen.
You are developing a mobile app that uses an Azure SQL Database named Weyland.
The database contains a table names Customers that has a field named email_address.
You want to implement dynamic data masking to hide the data in the email_address field.
Solution: You run the Set-AzSqlDatabaseDataMaskingRule -DatabaseName "Weyland" -SchemaName "dbo" -TableName"Customers" -ColumnName "email_address" -MaskingFunction "email" Powershell cmdlet Does the solution meet the goal?
Click on the arrows to vote for the correct answer
A. B.A.
https://docs.microsoft.com/en-us/powershell/module/az.sql/Set-AzSqlDatabaseDataMaskingRule?view=azps-4.2.0The solution presented, which is to run the PowerShell cmdlet Set-AzSqlDatabaseDataMaskingRule with the specified parameters, is correct and meets the goal of implementing dynamic data masking on the email_address field in the Customers table in the Weyland Azure SQL database.
Dynamic data masking is a security feature in Azure SQL Database that helps to prevent unauthorized access to sensitive data by obfuscating or masking it. The Set-AzSqlDatabaseDataMaskingRule PowerShell cmdlet is used to create or modify a data masking rule in an Azure SQL database.
In this solution, the cmdlet is being used to create a data masking rule for the email_address column in the Customers table in the Weyland database. The cmdlet specifies the parameters as follows:
This cmdlet will create a data masking rule on the email_address field that will mask the email addresses whenever they are retrieved from the database. This will help to protect sensitive information in the database by making it more difficult for unauthorized users to access it.
Therefore, the correct answer is A. Yes, the solution meets the goal of implementing dynamic data masking on the email_address field in the Customers table in the Weyland Azure SQL database.