Which of the following will enable this type of data ingestion?

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?
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.

View Answer

Answer: D

Explanation:

This is the correct answer because it allows the company to ingest data from different regions using a storage integration for the external stage. A storage integration is a feature that enables secure and easy access to files in external cloud storage from Snowflake. A storage integration can be used to create an external stage, which is a named location that references the files in the external storage.

An external stage can be used to load data into Snowflake tables using the COPY INTO command, or to unload data from Snowflake tables using the COPY INTO LOCATION command. A storage integration can support multiple regions and cloud platforms, as long as the external storage service is compatible with Snowflake12.

Reference: Snowflake Documentation: Storage Integrations

Snowflake Documentation: External Stages