nerdexam
Snowflake

COF-C02 · Question #53

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

The correct answer is D. A Windows server file share on Azure. When a Snowflake account is hosted on Microsoft Azure, the natural and supported external stage source is Azure-based cloud storage (Azure Blob Storage or Azure Data Lake Storage Gen2). Option D represents an Azure-native file storage path, making it the correct choice in this…

Data Loading and Unloading

Question

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Options

  • AAn FTP server with TLS encryption
  • BAn HTTPS server with WebDAV
  • CA Google Cloud storage bucket
  • DA Windows server file share on Azure

How the community answered

(24 responses)
  • A
    4% (1)
  • C
    4% (1)
  • D
    92% (22)

Explanation

When a Snowflake account is hosted on Microsoft Azure, the natural and supported external stage source is Azure-based cloud storage (Azure Blob Storage or Azure Data Lake Storage Gen2). Option D represents an Azure-native file storage path, making it the correct choice in this Azure-hosted context. Option A (FTP with TLS) is not a supported external stage protocol in Snowflake. Option B (HTTPS/WebDAV) is likewise not a recognized Snowflake stage source. Option C (Google Cloud Storage) is a valid stage type for Snowflake in general, but it is a cross-cloud option and not the expected answer when the account itself resides on Azure.

Topics

#External Stages#Azure Integration#Data Loading#Cloud Storage

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice