Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Snowflake supports loading data from external stages that are located on Amazon S3, Google Cloud Storage, and Microsoft Azure blob storage. A Google Cloud storage bucket is a valid source for an external stage when the Snowflake account is located on Microsoft Azure.
Correct answer is C. Snowflake supports loading data from files staged in any of the following locations, regardless of the cloud platform for your Snowflake account: • Internal (i.e. Snowflake) stages • Amazon S3 • Google Cloud Storage • Microsoft Azure blob storage
as it is MS based environment
It cannot be C. All resources must be in the same cloud environment.
https://docs.snowflake.com/en/user-guide/data-load-overview#external-stages Loading data from any of the following cloud storage services is supported regardless of the cloud platform that hosts your Snowflake account: Amazon S3 Google Cloud Storage Microsoft Azure
C is correct
C is correct
To my earlier question. The reason its Google storage being correct is, AZURE file share is not supported with Snowflake staging. Snowflake currently supports loading from blob storage only. Snowflake supports the following types of storage accounts. It does not contain the windows share in the list. Blob storage Data Lake Storage Gen2 General-purpose v1 General-purpose v2
MS Azure
Its not D. Snowflake does not support Auzre Windows Share. It only supports BLOB
changing the voting to C this is correct
The correct answer is D
Google storage is correct as AZURE file share is not supported with Snowflake staging.
https://docs.snowflake.com/en/sql-reference/sql/create-stage External stage References data files stored in a location outside of Snowflake. Currently, the following cloud storage services are supported: Amazon S3 buckets Google Cloud Storage buckets Microsoft Azure containers
Snowflake currently supports loading from blob storage only. Snowflake supports the following types of storage accounts: Blob storage Data Lake Storage Gen2 General-purpose v1 General-purpose v2
correct
I dont understand why some of them say C. Though Snowflake sits on the Azure from the questions, the external stage is anything out of snowflake. It could be Azure File share or it could be Google bucket. can someone clarify?
correct
You can hosted SF at one provide but access data via ext. stage from all three (S3 Bucket, Azure Blob, GCP as well).