Snowflake ADA-C01 Exam - Topic 2 Question 25 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 25
Topic #: 2

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 Lindsey at Sep 18, 2024, 03:36 AM

Limited Time Offer

25%

1 year 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

Lauran

1 year ago

User3: Snowflake sure knows how to keep things interesting with their naming conventions.

upvoted 0 times

...

Gene

1 year ago

User2: Yeah, that 'SYSTEMSGLOBAL_ACCOUNT_SET_PARAMETER' function name is quite a mouthful.

upvoted 0 times

...

Brianne

1 year ago

I think B is the way to go.

upvoted 0 times

...

Anglea

1 year 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

...

1 year 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