AZ-305 · Question #143
You have an Azure Data Lake Storage account that contains 1,000 10-MB CSV files and an Azure Synapse Analytics dedicated SQL pool named sql1. You need to load the files to sql1. The solution must…
The correct answer is B. PolyBase. To efficiently load 1,000 10-MB CSV files from Azure Data Lake Storage into an Azure Synapse Analytics dedicated SQL pool, maximizing performance and eliminating manual external table definitions, PolyBase should be used.
Question
Options
- Athe copy statement
- BPolyBase
- CBCP
- Dthe sqlBulkcopy object
How the community answered
(67 responses)- A13% (9)
- B75% (50)
- C4% (3)
- D7% (5)
Why each option
To efficiently load 1,000 10-MB CSV files from Azure Data Lake Storage into an Azure Synapse Analytics dedicated SQL pool, maximizing performance and eliminating manual external table definitions, PolyBase should be used.
While the `COPY` statement is a modern and often recommended syntax for loading data in Synapse Analytics, it leverages PolyBase or similar high-performance mechanisms internally; PolyBase represents the broader technology that fulfills the core requirements of parallel loading and external table interaction.
PolyBase is the underlying technology in Azure Synapse Analytics designed for high-throughput, parallel data ingestion from external sources like Azure Data Lake Storage. It can be used with commands like `CREATE EXTERNAL TABLE AS SELECT` or by enabling schema inference features to load data directly and efficiently without requiring explicit pre-definition of external tables, maximizing data load performance.
Concept tested: Azure Synapse Analytics data loading with PolyBase
Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/data-loading-best-practices
Community Discussion
No community discussion yet for this question.