Question: You are writing an app for a sales team. You need to implement security in SQL Server to ensure that sales representatives see customer financial information only for customers whom they manage. Your app must make this transparent to the user. Which SQL data security option should you choose?

1. Dynamic Data Masking
2. Transparent Data Encryption
3. Row-Level Security
4. Always Encrypted

Answer: The correct answer of the above question is Option A:Dynamic Data Masking