Exam SnowPro Core topic 1 question 320 discussion

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

In Snowflake, when the account is located on Microsoft Azure, a valid source for an external stage can be an Azure container or a folder path within an Azure container. This includes Azure Blob storage which is accessible via the azure:// endpoint. A Windows server file share on Azure, if configured properly, can be a valid source for staging data files for Snowflake. Options A, B, and C are not supported as direct sources for an external stage in Snowflake on Azure12.

Google storage is correct as AZURE file share is not supported with Snowflake staging.

C is correct

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

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

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

MS Azure

changing the voting to C this is correct

as it is MS based environment

You can hosted SF at one provide but access data via ext. stage from all three (S3 Bucket, Azure Blob, GCP as well).

It cannot be C. All resources must be in the same cloud environment.

The correct answer is D

C is correct