SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ32

Data Ingestion and Data Preparation

An Architect has decided to segregate their Snowflake Production and QA environments by using two distinct Snowflake accounts.

The QA account is meant to run and test changes to data and database objects before those changes are promoted to the Production account. All database objects and data in the QA account must be an exact copy of the database objects, including privileges and data, in the Production account at least nightly.

Which approach is the LEAST complex way to populate the QA account nightly with the Production account’s data and database objects?

Explanation

Snowflake database replication synchronizes a primary database’s contained objects and stored data to a secondary database in another account. A secondary database is read-only, so cloning the replica creates a writable QA database for testing without manually unloading, loading, or recreating database objects. When the relevant roles are replicated, database refreshes also synchronize supported privilege grants on the database and its objects.

Learn more

Community Discussion

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