Snowflake Exam ADA-C01 Topic 5 Question 38 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 38
Topic #: 5

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?

AUSE ROLE ORGADMIN;
SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER ('MYORG. ACCOUNT1', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE');
SELECT SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER ('MYORG. ACCOUNT2', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE');
USE ROLE ACCOUNTADMIN;
ALTER DATABASE PROD DB ENABLE REPLICATION TO ACCOUNTS MYORG. ACCOUNT2;

BUSE ROLE ORGADMIN;
SELECT SYSTEMSGLOBAL ACCOUNT SET_PARAMETER ( 'MYORG. ACCOUNT1', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'TRUE');
USE ROLE ACCOUNTADMIN;
ALTER DATABASE PROD_DB ENABLE REPLICATION TO ACCOUNTS MYORG. ACCOUNT2 IGNORE EDITION CHECK;

CNo configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.

DIt is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.

Show Suggested 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.

by Alyce at Jun 11, 2025, 03:16 AM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Roosevelt

2 days ago

I feel like option C might be correct since replication is often enabled by default, but I wouldn't bet on it without double-checking.

upvoted 0 times

...

Aja

8 days ago

I remember a practice question where we had to set parameters for replication, but I can't recall if we need to do it for both accounts or just one.

upvoted 0 times

...

Berry

13 days ago

I think we need to enable database replication in ACCOUNT1 first, but I'm not sure about the exact commands.

upvoted 0 times

...

Marylou

19 days ago

I think I've got a good handle on this. The key things to remember are to use the ORGADMIN role to enable replication at the account level, and then switch to ACCOUNTADMIN to actually replicate the database. As long as I follow those steps, I should be able to get this done.

upvoted 0 times

...

Levi

24 days ago

Okay, based on the options provided, it looks like we need to enable database replication at the account level first, and then we can actually replicate the database. The key steps seem to be using the ORGADMIN role to enable replication, and then using ACCOUNTADMIN to perform the replication itself.

upvoted 0 times

...

Mauricio

29 days ago

Hmm, I'm a bit confused about the different roles mentioned here. It says we need to use the ORGADMIN role in ACCOUNT1, but then switch to ACCOUNTADMIN for the actual replication step. I'll need to make sure I understand the permissions required for each step.

upvoted 0 times

...

Harrison

1 month ago

This looks like a pretty straightforward question about setting up database replication between Snowflake accounts. I think I'll start by reviewing the key details - we have two Snowflake accounts, ACCOUNT1 and ACCOUNT2, and the goal is to replicate the PROD_DB database from ACCOUNT1 to ACCOUNT2.

upvoted 0 times

...

Paul

4 months ago

Snowflake, where the only thing that's unique is the price tag. But hey, at least they make replicating databases a breeze (with the right configuration, of course).

upvoted 0 times

...

Edwin

4 months ago

I was about to choose C, but then I remembered that the replication feature is not enabled by default. Good catch on option B!

upvoted 0 times

Teresita

3 months ago

User2

upvoted 0 times

...

Malinda

3 months ago

User1

upvoted 0 times

...

Lauran

4 months ago

Ah, I see. So you need to set the replication parameter in both accounts before you can actually replicate the database. Makes sense.

upvoted 0 times

Margret

3 months ago

Option C states that no configuration steps are necessary in ACCOUNT1. Maybe we should double-check the documentation to confirm.

upvoted 0 times

...

Yuette

3 months ago

I agree, it's important to configure the replication settings in both accounts to ensure a successful replication process.

upvoted 0 times

...

Bong

3 months ago

Option A seems to be the correct one. You need to enable database replication in both accounts before initiating the replication process.

upvoted 0 times

...

Karrie

4 months ago

But B mentions enabling replication and ignoring edition check, which seems necessary for this scenario.

upvoted 0 times

...

Linsey

4 months ago

I disagree, I believe the correct answer is C.

upvoted 0 times

...

Karrie

5 months ago

I think the answer is B.

upvoted 0 times

...

Cassie

5 months ago

The correct answer is B. The ENABLE_ACCOUNT_DATABASE_REPLICATION parameter needs to be set in both ACCOUNT1 and ACCOUNT2 before the database replication can be configured.

upvoted 0 times