SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ123

Secure Data Sharing and Consumption

A company has two Snowflake accounts: one for production and one for non-production. The accounts reside in different cloud-provider regions. The company's data architecture includes a separate database for each of the stage, integration, and presentation layers.

The non-production account must receive nightly updates from the production stage-layer database.

What is the FASTEST way to update the data in the non-production account with the LEAST operational overhead?

Explanation

Snowflake database replication can synchronize a primary database to a secondary database across Snowflake accounts in different regions and cloud platforms. Scheduling a nightly refresh provides an automated copy of the production staging database without building and operating an unload, ingestion, or data-pipeline process. Direct secure data shares are limited to consumer accounts in the same Snowflake region.

Learn more

Community Discussion

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