SnowPro Advanced: Architect — Question 114

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

The non-production account needs to have data updated every night from the production stage layer database.

What is the FASTEST way to update the non-production account data using the LEAST amount of operational overhead?

Answer options

• A. Clone the staging data from the production account to the non-production account.
• B. Create a secure data share of the staging data from the production account to the non-production account.
• C. Unload the staging data from the production account and ingest it in the non-production account using Snowpipe.
• D. Set up database replication of the staging database from the production to the non-production account and schedule a task for a nightly refresh.

Correct answer: D

Explanation

Option D is correct because database replication allows for real-time data updates with minimal manual intervention, making it efficient for nightly refreshes. In contrast, option A involves cloning, which may not reflect real-time changes; option B, while secure, does not provide the same level of operational efficiency for updates; and option C requires unloading and reloading data, which is more labor-intensive and slower.