Implementing Dynamic Data Masking in Azure SQL Database | Exam AZ-204 Solution
Question
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 follows transact-SQL statement: ALTER TABLE [dbo].[Weyland].[Customers] ALTER COLUMN [email_address] ADD MASKED WITH (FUNCTION = 'email()') Does the solution meet the goal?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B.A.
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-ver15Yes, the provided solution meets the goal of implementing dynamic data masking to hide the data in the email_address field.
Explanation:
Dynamic Data Masking is a security feature in Azure SQL Database that helps to limit the exposure of sensitive data by masking it to non-privileged users. Dynamic Data Masking does not modify the actual data stored in the database, but it hides the data from non-privileged users. This is useful when you have data that needs to be protected from unauthorized access but needs to be available for legitimate users.
The provided solution uses the correct Transact-SQL statement to implement Dynamic Data Masking for the email_address field of the Customers table in the Weyland database. The ALTER TABLE statement is used to modify the table schema, and the ALTER COLUMN statement is used to modify the email_address column. The ADD MASKED WITH clause is used to apply the masking function, and the email() function is used to mask the email addresses.
Therefore, the provided solution is correct and will successfully implement Dynamic Data Masking to hide the data in the email_address field.
