Question

A famous fintech startup is setting up its data solution using Azure Synapse analytics. As part of compliance, the company has decided that only the finance managers should be able to see the Bank Account Number and not anyone else. Which of the following is best suited in this scenario?

A. Firewall rules to block IP

B. Row-level security

C. Column-level security

D. Azure RBAC role

Answer 1

Correct Answer: C

Reason:-

Column-level security will control the access to particular columns based on the user membership. In the case of sensitive data, we can decide which user or group can access a particular column. In this question, the restriction should be given to Bank account numbers. So, ideally column-level security can be used.

Option A is incorrect: Firewall block will completely block access to the database.

Option B is incorrect: Row-level security will prevent access to row and is not required.

Option C is correct: It will be the best solution.

Option D is incorrect: Azure RBAC cannot control access to a particular column.