Which statement is true about replication of policy-protected objects?

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

Which statement is true about replication of policy-protected objects?

Explanation:
Policy-protected objects rely on features that are edition-specific in Snowflake. When you replicate a primary database that contains a policy to accounts, the target accounts must support the same security capabilities. If the primary is in an Enterprise (or higher) edition and a replication target is on a lower edition, those policy features aren’t available there, so the replication operation is blocked to prevent security inconsistencies. That’s why the statement about replication failing under an Enterprise or higher primary with policy when any replication target is on a lower edition is the true behavior. The other scenarios don’t reflect this edition-based restriction. Replication isn’t guaranteed to proceed simply because a policy exists in the same database, and policies themselves aren’t always replicated as independent objects without considering edition compatibility. Cross-database references to policies can also introduce dependencies that aren’t accommodated by replication, but the mandated failure condition described is specifically about edition compatibility across accounts.

Policy-protected objects rely on features that are edition-specific in Snowflake. When you replicate a primary database that contains a policy to accounts, the target accounts must support the same security capabilities. If the primary is in an Enterprise (or higher) edition and a replication target is on a lower edition, those policy features aren’t available there, so the replication operation is blocked to prevent security inconsistencies. That’s why the statement about replication failing under an Enterprise or higher primary with policy when any replication target is on a lower edition is the true behavior.

The other scenarios don’t reflect this edition-based restriction. Replication isn’t guaranteed to proceed simply because a policy exists in the same database, and policies themselves aren’t always replicated as independent objects without considering edition compatibility. Cross-database references to policies can also introduce dependencies that aren’t accommodated by replication, but the mandated failure condition described is specifically about edition compatibility across accounts.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy