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.
Q. 1: Solution: You run the follows transact-SQL statement:
ALTER TABLE [dbo].[Weyland].[Customers]
ALTER COLUMN [email_address]
ADD MASKED WITH (FUNCTION = ’email()’)
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: A
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15
Q. 2: Solution: You run the Set-AzSqlDatabaseDataMaskingPolicy -DatabaseName "Weyland" Powershell cmdlet
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: B
The Set-AzSqlDatabaseDataMaskingPolicy cmdlet sets the masking policy for the database but does not set the masking rule.
Note: Masking is enabled by default.
Q. 3: 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?
Does the solution meet the goal?
A. Yes
B. No
Correct Answer: A