Static Data Masking and Dynamic Data Masking are two data masking options offered by Microsoft. Which of the following statements(s) are true about Static and Dynamic Data Masking. (Select all that are applicable)

Answer options:

A.Static data masking takes place on the original database whereas dynamic data masking takes place on a copy of the database.
B.Dynamic data masking takes place on the original database whereas static data masking takes place on a copy of the database.
C.In Static Data Masking, the mask takes place at the storage level while in the case of dynamic data masking, the mask takes place on the fly at query time.
D.In Dynamic Data Masking, the mask takes place at the storage level while in the case of static data masking, the mask takes place on the fly at query time.
E.In static as well as Dynamic Data Masking, all users have access to the same masked data.

Correct Answers: B and C 
The below table highlights the differences between Static Data Masking and Dynamic Data Masking. 

Option A is incorrect. Dynamic data masking takes place on the original database whereas static data masking takes place on a copy of the database.
Option B is correct. Dynamic data masking takes place on the original database whereas static data masking takes place on a copy of the database.
Option C is correct. In Static Data Masking, the mask takes place at the storage level while in the case of dynamic data masking, the mask takes place on the fly at query time.
Option D is incorrect. The given statement is not true.
Option E is incorrect. Only in static data masking, all users have access to the same masked data. In Dynamic Data Masking, the mask varies depending upon the user’s permission.
References:
To know more about static data masking and dynamic data masking, please visit the below-given links: 

https://azure.microsoft.com/en-in/blog/static-data-masking-preview/
https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview