SnowPro Advanced: Architect — Question 58

A company has several sites in different regions from which the company wants to ingest data.
Which of the following will enable this type of data ingestion?

Answer options

• A. The company must have a Snowflake account in each cloud region to be able to ingest data to that account.
• B. The company must replicate data between Snowflake accounts.
• C. The company should provision a reader account to each site and ingest the data through the reader accounts.
• D. The company should use a storage integration for the external stage.

Correct answer: D

Explanation

The correct answer is D because using a storage integration for the external stage allows for efficient and centralized data ingestion from multiple sites without the need for separate accounts in each region. Options A and B suggest more complex setups that are unnecessary for this requirement, while option C implies creating multiple reader accounts, which is not the most efficient method for data ingestion.