Black Friday Reward - Upto 75% off - Ends in 0d 00h 00m 00s - Coupon code: CFsave75

Snowflake SnowPro Advanced: Administrator ADA-C02 Question # 10 Topic 2 Discussion

Snowflake SnowPro Advanced: Administrator ADA-C02 Question # 10 Topic 2 Discussion

ADA-C02 Exam Topic 2 Question 10 Discussion:
Question #: 10
Topic #: 2

A Snowflake organization, MYORG, contains two Snowflake accounts:

ADA-C02 Question 10

ACCOUNT1 has a database named PROD_DB and has the ORGADMIN role enabled. Management wants PROD_DB replicated to ACCOUNT2.


A.

re any configuration steps required in ACCOUNT1 before database replication can be configured and started in ACCOUNT2?


B.

USE ROLE ORGADMIN;

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(

'MYORG.ACCOUNT1',

'ENABLE_ACCOUNT_DATABASE_REPLICATION',

'TRUE'

);

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(

'MYORG.ACCOUNT2',

'ENABLE_ACCOUNT_DATABASE_REPLICATION',

'TRUE'

);

USE ROLE ACCOUNTADMIN;

ALTER DATABASE PROD_DB

ENABLE REPLICATION TO ACCOUNTS MYORG.ACCOUNT2;


C.

USE ROLE ORGADMIN;

SELECT SYSTEM$GLOBAL_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;


D.

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


E.

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


Get Premium ADA-C02 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.