ADA-C02: SnowPro Advanced — Administrator

By Snowflake · Question Mode

QuestionQ52

VerifiedImplement disaster recovery, perform backups, and replicate data

A company has enabled replication between accounts and is ready to replicate data across Regions within the same cloud service provider.

The primary database object is: PROD_AWS_EAST. Location: AWS_EAST.

The secondary database object is: PROD_AWS_WEST. Location: AWS_WEST.

What command and account location are required to refresh the data?

Explanation

A secondary Snowflake database is refreshed from a snapshot of its primary database with ALTER DATABASE <secondary_database_name> REFRESH. The command is run in the account that contains the secondary database, so ALTER DATABASE PROD_AWS_WEST REFRESH must be executed in AWS_WEST.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!