Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam
Go to Exam

Exam SnowPro Advanced Architect topic 1 question 23 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect
Question #: 23
Topic #: 1
[All SnowPro Advanced Architect Questions]

An Architect has chosen to separate their Snowflake Production and QA environments using two separate Snowflake accounts.
The QA account is intended to run and test changes on data and database objects before pushing those changes to the Production account. It is a requirement that all database objects and data in the QA account need to be an exact copy of the database objects, including privileges and data in the Production account on at least a nightly basis.
Which is the LEAST complex approach to use to populate the QA account with the Production account’s data and database objects on a nightly basis?

  • A. 1. Create a share in the Production account for each database
    2. Share access to the QA account as a Consumer
    3. The QA account creates a database directly from each share
    4. Create clones of those databases on a nightly basis
    5. Run tests directly on those cloned databases
  • B. 1. Create a stage in the Production account
    2. Create a stage in the QA account that points to the same external object-storage location
    3. Create a task that runs nightly to unload each table in the Production account into the stage
    4. Use Snowpipe to populate the QA account
  • C. 1. Enable replication for each database in the Production account
    2. Create replica databases in the QA account
    3. Create clones of the replica databases on a nightly basis
    4. Run tests directly on those cloned databases
  • D. 1. In the Production account, create an external function that connects into the QA account and returns all the data for one specific table
    2. Run the external function as part of a stored procedure that loops through each table in the Production account and populates each table in the QA account
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by callipso21 at April 18, 2023, 9:55 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
NachoPrendes
4 months, 1 week ago
Selected Answer: C
But it is not "shared", is "replicated". And we can create a clone from a replicated database. It's C
upvoted 1 times
...
rkarthik0789
5 months, 3 weeks ago
The least complex approach among the options provided is likely option B. This approach involves setting up a shared stage between the Production and QA accounts and utilizing Snowpipe for data ingestion. Snowpipe can automatically load data from the stage into the QA environment, simplifying the process and reducing the need for manual intervention. Additionally, unloading data from the Production account into a stage is a straightforward task, and Snowpipe's automated data loading capabilities streamline the process further.
upvoted 1 times
...
anikl
1 year ago
Share database cannot be cloned. therefore A is wrong, C is correct
upvoted 2 times
...
hillcat111
1 year, 4 months ago
Answer is C and is validated
upvoted 1 times
...
victorleonis
1 year, 5 months ago
Selected Answer: C
Ans C is incorrect. We can clone a shared object.
upvoted 2 times
...
Dhamod
1 year, 6 months ago
https://community.snowflake.com/s/article/Snowflake-DTAP-Environment-Setup Ans: C
upvoted 2 times
...
callipso21
1 year, 7 months ago
Selected Answer: C
https://community.snowflake.com/s/article/How-to-Copy-a-Database-from-One-account-to-Another
upvoted 4 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel