A company has an Azure SQL data warehouse. They want to use PolyBase to retrieve data from an Azure Blob storage account and ingest into the Azure SQL data warehouse. The files are Which of the follow

Question

Options

• ACreate an external file format that would map to the parquet-based files
• BLoad the data into a staging table
• DCreate an external data source for the Azure Blob storage account
• ECreate a master key on the database
• FConfigure Polybase to use the Azure Blob storage account

• A
  12% (5)
• B
  84% (36)
• F
  5% (2)

Explanation

PolyBase Ingestion from Azure Blob Storage

Note: The listed correct answer (B, D, E) appears incomplete - the question asks for 4 answers, and since the files are parquet-based, A is also required. The full correct set is A, B, D, E.

Implementing PolyBase follows a specific sequence: you must first create a master key (E) to enable database-scoped credentials that authenticate against external sources, then create an external data source (D) to tell PolyBase where the blob storage lives, then create an external file format (A) to describe the parquet schema so PolyBase can parse the files, and finally load data into a staging table (B), which is the standard practice for transforming and ingesting external data before moving it to the final destination table.

F is wrong because "configuring PolyBase to use the blob storage account" is not a discrete step - that's exactly what creating the external data source (D) accomplishes; there is no separate PolyBase configuration command.

Memory tip: Think of the PolyBase setup as building a pipeline from the outside in - Key → Credential → Source → Format → External Table → Stage (KCSFES). On the exam, if you see PolyBase + blob storage, the master key and external data source are almost always required, and file format is required whenever the source isn't a simple delimited text file.

No community discussion yet for this question.