nerdexam
Microsoft

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.

Submitted by thandi_sa· Mar 6, 2026Design data storage solutions

Question

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 meet the following requirements: - Maximize data load performance. - Eliminate the need to define external tables before the data loads. What should you use?

Options

  • Athe copy statement
  • BPolyBase
  • CBCP
  • Dthe sqlBulkcopy object

How the community answered

(67 responses)
  • A
    13% (9)
  • B
    75% (50)
  • C
    4% (3)
  • D
    7% (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.

Athe copy statement

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.

BPolyBaseCorrect

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.

CBCP
Dthe sqlBulkcopy object

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.

Full AZ-305 Practice