Exam DP-203 topic 9 question 2 discussion

Answer is C https://azure.microsoft.com/en-ca/updates/column-level-security-is-now-supported-in-azure-sql-data-warehouse/ You can use CLS to manage user access to specific columns in your tables in a simpler manner, without having to redesign your data warehouse. CLS eliminates the need to maintain access restriction logic away from the data in another application or introduce views for filtering out sensitive columns for a subset of users.

Answer is C

C. Azure SQL Data Warehouse now supports column-level security (CLS), an additional capability for managing sensitive data in the cloud. You can use CLS to manage user access to specific columns in your tables in a simpler manner, without having to redesign your data warehouse. CLS eliminates the need to maintain access restriction logic away from the data in another application or introduce views for filtering out sensitive columns for a subset of users. To help secure your data, simply define a security policy on your table columns with the standard GRANT T-SQL statement.

is correct

Option C, column-level security, allows you to control access to specific columns within a table based on user permissions. This means you can restrict access to sensitive customer contact information, such as phone numbers, only to authorized users or roles within the organization. By implementing column-level security, you can ensure that business analysts are limited in their access to customer contact information, preventing them from viewing or analyzing the phone numbers, which are not analytically relevant in this case.

Answer is 100% C. The only way you can prevent users from seeing sensitive information is either through partial masking (partially visible) or complete blocking by using column level security.

Correct Answer is C i.e. Column-level security !!

The answer is D. Between C and D, D can "minimize the number of different Azure services needed to achieve the business goals." But C needs to distribute role to the user, that is more complicated to apply.

C - column level security is correct

La verdad que no queda nada claro

It's C because of this requirement : "Limit the business analysts' access to customer contact information, such as phone numbers, because this type of data is not analytically relevant."

It's tricky, because it says "secure" and not "not to access"

Even in udemy also the answer is same as ' Data sensitivity labels'

You don't secure data with sensitivity labels. They can only be used to identify who has accessed sensitive data. So it has to be column level security. There should really have been a Data Masking option here instead of column level security.

It should be C, because only analysts are might not see those columns but others yes

column level security is correct answer

I fee it's C as we can limit access via CLS.