You work in Azure Synapse Analytics dedicated SQL pool that has a table titled Pilots. Now you want to restrict the user access in such a way that users in ‘IndianAnalyst’ role can see only the pilots from India.Which of the following would you add to the solution?

Answer options:

A.Table partitions
B.Encryption
C.Column-Level security
D.Row-level security
E.Data Masking

Correct Answer: D 
Row-level security is applicable on databases to allow fine-grained access to the rows in a database table for restricted control upon who could access which type of data.
Option A is incorrect. Table partitions are generally used to group similar data.
Option B is incorrect. Encryption is used for security purposes.
Option C is incorrect. Column level security is used to restrict data access at the column level. In the given scenario, we need to restrict access at the row level.
Option D is correct. In this scenario, we need to restrict access on a row basis, i.e only for the pilots from India, there Row-level security is the right solution.
Option E is incorrect. Sensitive data exposure can be limited by masking it to unauthorized users using SQL Database dynamic data masking.
References: 
To know more about Row-level security, please visit the below-given links: 

https://azure.microsoft.com/en-in/resources/videos/row-level-security-in-azure-sql-database/
https://techcommunity.microsoft.com/t5/azure-synapse-analytics/how-to-implement-row-level-security-in-serverless-sql-pools/ba-p/2354759