ARA-C01 Question #159: Real Exam Question with Answer & Explanation

Question

Company A has recently acquired company B. The Snowflake deployment for company B is located in the Azure West Europe region. As part of the integration process, an Architect has been asked to consolidate company B's sales data into company A's Snowflake account which is located in the AWS us-east-1 region. How can this requirement be met?

Options

• AReplicate the sales data from company B's Snowflake account into company A's Snowflake
• BExport the sales data from company B's Snowflake account as CSV files, and transfer the files to
• CMigrate company B's Snowflake deployment to the same region as company A's Snowflake
• DBuild a custom data pipeline using Azure Data Factory or a similar tool to extract the sales data

Explanation

The best way to meet the requirement of consolidating company B's sales data into company A's Snowflake account is to use cross-region data replication within Snowflake. This feature allows data providers to securely share data with data consumers across different regions and cloud platforms. By replicating the sales data from company B's account in Azure West Europe region to company A's account in AWS us-east-1 region, the data will be synchronized and available for consumption. To enable data replication, the accounts must be linked and replication must be enabled by a user with the ORGADMIN role. Then, a replication group must be created and the sales database must be added to the group. Finally, a direct share must be configured from company B's account to company A's account to grant access to the replicated data. This option is more efficient and secure than exporting and importing data using CSV files or migrating the entire Snowflake deployment to another region or cloud platform. It also does not require building a custom data pipeline using external tools.

No community discussion yet for this question.