Which storage options and file formats are supported for COPY when using Transact-SQL in Warehouse?

Which storage options and file formats are supported for COPY when using Transact-SQL in Warehouse?

• A. Azure Data Lake Storage (ADLS) Gen2 and Azure Blob Storage, PARQUET and CSV
• B. Azure Data Lake Storage (ADLS) Gen1 and Azure Blob Storage, ORC
• C. Azure Data Lake Storage (ADLS) Gen2 and Amazon S3, PARQUET and JSON
• D. Azure Data Lake Storage (ADLS) Gen1 and Google Cloud Storage, PARQUET and CSV

Answer: (A)

The question is about what you can import with COPY in Transact-SQL in Warehouse. The supported setup includes two Azure storage options—Azure Data Lake Storage Gen2 and Azure Blob Storage—and two file formats—PARQUET and CSV. This pairing makes sense because the platform is designed to read data directly from Azure data stores commonly used for big data workloads, and it supports both a columnar format (PARQUET) for efficient querying and a simple row-based format (CSV) for straightforward data loads. The other options mix in storage services that aren’t supported in this context (like ADLS Gen1, Amazon S3, or Google Cloud Storage) or formats not listed as supported (like ORC or JSON). So the correct combination is using ADLS Gen2 or Azure Blob Storage with PARQUET or CSV.

The question is about what you can import with COPY in Transact-SQL in Warehouse. The supported setup includes two Azure storage options—Azure Data Lake Storage Gen2 and Azure Blob Storage—and two file formats—PARQUET and CSV. This pairing makes sense because the platform is designed to read data directly from Azure data stores commonly used for big data workloads, and it supports both a columnar format (PARQUET) for efficient querying and a simple row-based format (CSV) for straightforward data loads. The other options mix in storage services that aren’t supported in this context (like ADLS Gen1, Amazon S3, or Google Cloud Storage) or formats not listed as supported (like ORC or JSON). So the correct combination is using ADLS Gen2 or Azure Blob Storage with PARQUET or CSV.