Answer-first summary for fast verification
Answer: Column-level security limits access to specific columns within a table based on user privileges., Column-level security allows the application of a masking policy to a column within a table or view.
The question asks how column-level security contributes to protecting sensitive information in Snowflake, requiring selection of two correct options. Option D is correct because column-level security specifically limits access to certain columns based on user privileges, directly protecting sensitive data by restricting visibility. Option E is correct as column-level security allows applying masking policies to columns, which dynamically masks sensitive data based on user context. Option A is incorrect because column-level security does not optimize query performance; it may slightly impact it due to additional security checks. Option B is incorrect as column-level security does not encrypt the entire database; encryption is handled separately at the storage level. Option C is incorrect because column-level security is not limited to the table owner; it can be configured for various roles and users. The community discussion shows 100% consensus on DE, with upvoted comments confirming these options as correct.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Choose two.)
A
Implementation of column-level security will optimize query performance.
B
Column-level security supports encryption of the entire database.
C
Column-level security ensures that only the table owner can access the data.
D
Column-level security limits access to specific columns within a table based on user privileges.
E
Column-level security allows the application of a masking policy to a column within a table or view.
No comments yet.