Answer-first summary for fast verification
Answer: They provide centralized privilege management with the schema owner.
Managed access schemas centralize privilege management by ensuring only the schema owner (or roles with MANAGE GRANTS privilege) can grant privileges on objects within the schema. This prevents individual object owners from making independent grant decisions, thereby enhancing data governance through centralized control and reducing the risk of unauthorized access. Option B correctly describes this centralized privilege management feature. Option A is incorrect because managed access schemas don't specifically log all operations or enable fine-grained auditing beyond standard Snowflake capabilities. Option C is incorrect because managed access schemas don't enforce identical privileges across all objects; they centralize the management of potentially different privileges. Option D is incorrect because managed access schemas don't require masking and row access policies on every table and view.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
How do managed access schemas contribute to data governance?
A
They log all operations and enable fine-grained auditing.
B
They provide centralized privilege management with the schema owner.
C
They enforce identical privileges across all tables and views in a schema.
D
They require the use of masking and row access policies across every table and view in the schema.