What are the supported data sources and file formats for the COPY (Transact-SQL) statement in Warehouse?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Prepare for the Fabric Analytics Engineer Associate Test with comprehensive materials. Explore flashcards, multiple choice questions, and detailed explanations. Get ready for your success!

Multiple Choice

What are the supported data sources and file formats for the COPY (Transact-SQL) statement in Warehouse?

Explanation:
COPY loads data into the warehouse from external storage and supports specific data sources and file formats. The supported sources are Azure Data Lake Storage Gen2 and Azure Blob Storage, which align with modern cloud analytics workflows. It does not support ADLS Gen1, and ORC is not listed as a supported file format for this operation. The formats that can be ingested are Parquet and CSV, which cover both efficient columnar storage and simple delimited text ingestion. This combination—Gen2 and Blob Storage with Parquet and CSV—is the correct match for what the COPY statement can read today.

COPY loads data into the warehouse from external storage and supports specific data sources and file formats. The supported sources are Azure Data Lake Storage Gen2 and Azure Blob Storage, which align with modern cloud analytics workflows. It does not support ADLS Gen1, and ORC is not listed as a supported file format for this operation. The formats that can be ingested are Parquet and CSV, which cover both efficient columnar storage and simple delimited text ingestion. This combination—Gen2 and Blob Storage with Parquet and CSV—is the correct match for what the COPY statement can read today.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy