Snowflake ADA-C01 Question Answer
In which scenario will use of an external table simplify a data pipeline?
When accessing a Snowflake table from a relational database
When accessing a Snowflake table from an external database within the same region
When continuously writing data from a Snowflake table to external storage
When accessing a Snowflake table that references data files located in cloud storage
The Answer Is:
DExplanation:
According to the Introduction to External Tables documentation, an external table is a Snowflake feature that allows you to query data stored in an external stage as if the data were inside a table in Snowflake. The external stage is not part of Snowflake, so Snowflake does not store or manage the stage. This simplifies the data pipeline by eliminating the need to load the data into Snowflake before querying it. External tables can access data stored in any format that the COPY INTO
