I have read about Dynamic Data Masking and one question is still in my mind. I am wondering what will happen is such scenario: 1. Dynamic Data Masking is set up on table 2. ETL process is loading new rows using NOLOCK hint (read uncommited) 3. During data load, execute select statement with read uncommited isolation level to get "dirty read" rows.

Does this "dirty data" will masked or not?

1 Answer 1


Dynamic Data Masking doesn't affect stored pages and it will work the same way with any transaction isolation level.

from Microsoft documentation(https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15):

Dynamic data masking is easy to use with existing applications, since masking rules are applied in the query results.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.