Exam SnowPro Advanced Data Engineer All QuestionsBrowse all questions from this exam
Question 34

Which stages support external tables?

    Correct Answer: C

    External stages in Snowflake are storage locations outside of the Snowflake account, such as Amazon S3, Azure Blob Storage, or Google Cloud Storage. These stages support all regions and cloud providers, offering flexibility for data loading and unloading. Therefore, the correct stage that supports external tables is the external stage which can be from any region and any cloud provider.

Discussion
BigDataBBOption: C

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. https://docs.snowflake.com/en/user-guide/tables-external-intro So the correct answer is C

prshntdxt7Option: C

C. External stages only; from any region, and any cloud provider External stages in Snowflake allow you to load or unload data from cloud-based storage locations (e.g., Amazon S3, Azure Blob Storage, Google Cloud Storage) without using a Snowflake stage. External stages provide flexibility in terms of storage locations and cloud providers.

stopthisnowOption: C

C makes sense. External stage can retrieve from any region and different cloud providers