SnowPro Advanced: Architect — Question 107

A Snowflake Architect is setting up database replication to support a disaster recovery plan. The primary database has external tables.

How should the database be replicated?

Answer options

• A. Create a clone of the primary database then replicate the database.
• B. Move the external tables to a database that is not replicated, then replicate the primary database.
• C. Replicate the database ensuring the replicated database is in the same region as the external tables.
• D. Share the primary database with an account in the same region that the database will be replicated to.

Correct answer: B

Explanation

Option B is correct because external tables cannot be replicated, so moving them to a non-replicated database allows the primary database to be replicated without issues. Option A is incorrect because cloning does not solve the issue with external tables. Option C is wrong since the replication of external tables is not supported, and Option D does not address the requirement for the external tables.