DP-203 · Question #264
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 Acc
The correct answer is C. Column-level security. 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, ideall
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?
Options
- AFirewall rules to block IP
- BRow-level security
- CColumn-level security
- DAzure RBAC role
How the community answered
(28 responses)- A4% (1)
- B11% (3)
- C82% (23)
- D4% (1)
Explanation
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. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-
Topics
Community Discussion
No community discussion yet for this question.