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…

Question

Options

• ATable partitions
• BEncryption
• CColumn-Level security
• DRow-level security
• EData Masking

• B
  12% (4)
• C
  6% (2)
• D
  79% (26)
• E
  3% (1)

Explanation

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. 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

No community discussion yet for this question.