Correct Answer: D
Reason:-
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.
Sources:: 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
