SnowPro Core Certification — Question 547

How do managed access schemas help with data governance?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer, B, is accurate because managed access schemas centralize privilege management, allowing the schema owner to control access effectively. Options A, C, and D describe functions that are not the primary purpose of managed access schemas; while they may relate to data governance, they do not highlight the centralization aspect which is crucial in this context.