SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ67

Design and Manage Snowflake Resources and Performance

To satisfy governance requirements, a company must fully isolate its production environment from its development and testing environments. The solution must also prevent zero-copy cloning.

How can these requirements be satisfied?

Explanation

Separate Snowflake accounts provide account-level isolation between production, development, and testing. Zero-copy cloning is performed by the CREATE <object> … CLONE command on existing objects within an account; isolating each environment in its own account prevents a production object from being zero-copy cloned into a nonproduction environment. Databases, schemas, and RBAC within one account remain within the same cloning boundary.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!