Exam SnowPro Advanced Architect topic 1 question 139 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 139
Topic #: 1

[All SnowPro Advanced Architect Questions]

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?

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.

Show Suggested Answer

Suggested Answer: D 🗳️

by ArunH at Nov. 26, 2025, 7:25 p.m.

Comments

Submit Cancel

ArunH

23 hours, 24 minutes ago

Selected Answer: B

Why not secure data sharing, less overhead, less issues, less cost and always current.

upvoted 1 times

...