Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam ADA-C01 Topic 2 Question 25 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 25
Topic #: 2
[All ADA-C01 Questions]

A Snowflake organization MYORG consists of two Snowflake accounts:

The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled.

Management wants to have the PROD_DB database replicated to ACCOUNT2.

Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?

Show Suggested Answer Hide Answer
Suggested Answer: B

According to the Snowflake documentation1, database replication across accounts within the same organization requires the following steps:

* Link the accounts in the organization using the ORGADMIN role.

* Enable account database replication for both the source and target accounts using the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function.

* Promote a local database to serve as the primary database and enable replication to the target accounts using the ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command.

* Create a secondary database in the target account using the CREATE DATABASE ... FROM SHARE command.

* Refresh the secondary database periodically using the ALTER DATABASE ... REFRESH command.

Option A is incorrect because it does not include the step of creating a secondary database in the target account. Option C is incorrect because replicating databases across accounts within the same organization is not enabled by default, but requires enabling account database replication for both the source and target accounts. Option D is incorrect because it is possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account, as long as the IGNORE EDITION CHECK option is used in the ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command2. Option B is correct because it includes all the necessary configuration steps in ACCOUNT1, except for creating a secondary database in ACCOUNT2, which can be done after the replication is enabled.


Contribute your Thoughts:

Breana
3 days ago
I'd go with B, but I can't help but laugh at the idea of a 'SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER' function. Snowflake really does have some entertaining naming conventions!
upvoted 0 times
...
Anglea
7 days ago
Hmm, I'm a little unsure about this one. The steps seem a bit complex, but I guess that's the nature of Snowflake administration. I wonder if there's a simpler way to achieve the same result?
upvoted 0 times
...
Shakira
8 days ago
I'm not sure about the steps required, but I know that database replication is a crucial feature for maintaining data consistency across accounts. This question seems to be testing our understanding of the Snowflake architecture and administration tools.
upvoted 0 times
...
Frederica
13 days ago
But B includes the necessary configuration steps in ACCOUNT1 before replication can be initiated in ACCOUNT2.
upvoted 0 times
...
Maile
14 days ago
The answer has to be B. The steps mention setting the account-level parameter to enable database replication, and then using the ACCOUNTADMIN role to enable replication for the specific database.
upvoted 0 times
Ronna
2 days ago
Are you sure about that?
upvoted 0 times
...
Marsha
8 days ago
B
upvoted 0 times
...
...
Brice
15 days ago
I disagree, I believe the correct answer is C.
upvoted 0 times
...
Frederica
28 days ago
I think the answer is B.
upvoted 0 times
...

Save Cancel