SnowPro Advanced: Architect — Question 138

The company, myorg, has multiple Snowflake accounts. An Architect found one of the accounts, account1, does not have replication enabled.

Executing which query will enable replication on account1?

Answer options

• A. SELECT SYSTEM$DISABLE_DATABASE_REPLICATION('myorg.account1'), 'false';
• B. SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('myorg.account1', 'true');
• C. SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('myorg.account1', 'SYSTEM$DISABLE_DATABASE_REPLICATION', "false");
• D. SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('myorg.account1', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', "true");

Correct answer: D

Explanation

The correct answer is D because it specifically enables replication for account1 by setting the 'ENABLE_ACCOUNT_DATABASE_REPLICATION' parameter to 'true'. Options A and C incorrectly focus on disabling replication, while option B does not specify the correct parameter needed to enable replication.