nerdexam
Snowflake

ARA-C01 · Question #9

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?

The correct answer is D. The company should use a storage integration for the external stage.. 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 i

Data Integration and Pipelines

Question

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?

Options

  • AThe company must have a Snowflake account in each cloud region to be able to ingest data to that
  • BThe company must replicate data between Snowflake accounts.
  • CThe company should provision a reader account to each site and ingest the data through the
  • DThe company should use a storage integration for the external stage.

How the community answered

(28 responses)
  • A
    7% (2)
  • B
    4% (1)
  • C
    4% (1)
  • D
    86% (24)

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

Topics

#Data Ingestion#Storage Integration#External Stages#Multi-Region Data Loading

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice