You are working on a project for a healthcare provider that provides health care services to the customers. The healthcare provider wants that only nurses and doctors must be able to access medical records. It should not be visible to the billing department. Which of the following types of security would you implement in this scenario?

Answer options:

A.Column-level security
B.Row-level security
C.Dynamic Data Masking
D.Table Level Security

Correct Answer: A 
Column level security is used to restrict the column access to protect the sensitive data. If you want that only some specific person or department shouldbe able to view some data, column-level security works the best.Option A is correct. As we want only nurses and doctors to be able to access medical records and records should not be visible to the billing department, column-level security will do the required.
Option B is incorrect. Row-level security is the feature that can be applied on databases to enable fine-grained access over rows in a database table for restricted control upon who can access which type of data.
Option D is incorrect. Dynamic data masking won’t help in restricting the column access only to some specific persons.
Option D is incorrect. Table Level Security is not a good choice.
References:
To know more about column level security, please visit the below-given link: 

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/column-level-security
https://azure.microsoft.com/en-us/blog/column-level-security-is-now-supported-in-azure-sql-data-warehouse/