You work in a company that provides financial services to its customers. The company wants to allow only its account managers to access the Social Service Number, Emails and other personal information. Which of the following types of security will suit best in this scenario?

Answer options:

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

Correct Answer: B 
Column-level security allows restricting column access to protect the private or sensitive data. For instance, if you need to ensure that a particular user `Smith` can only access specific columns of a table, column-level security helps here. Column-level security can be implemented with the GRANT T-SQL statement.
Option A is incorrect. Row-level security can be applied on databases to allow fine-grained access over the rows in a table for restricted control upon who can access which type of data.
Option B is correct. As we need to restrict column access and allow only the account managers to access the Social Service Number,Emails and other personal information, column-level security will work here.
Option C is incorrect. Table Level Security is not the right option.
Option D is incorrect. Dynamic data masking masks the data but here we need to restrict the column data access therefore column-level security is the right option.
Reference: 
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