ADA-C01 · Question #19
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…
The correct answer is B. USE ROLE ORGADMIN. 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…
Question
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?
Exhibit
Options
- AUSE ROLE ORGADMIN;
- BUSE ROLE ORGADMIN;
- CNo configuration steps are necessary in ACCOUNT1. Replicating databases across accounts
- DIt is not possible to replicate a database from an Enterprise edition Snowflake account to a
How the community answered
(54 responses)- A4% (2)
- B70% (38)
- C7% (4)
- D19% (10)
Explanation
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 - Refresh the secondary database periodically using the ALTER DATABASE ... REFRESH
Topics
Community Discussion
No community discussion yet for this question.