Implementing an Azure Data Solution (legacy) — Question 57

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 stored in parquet format. The data needs to be loaded into a table called XYZ_sales.
Which of the following actions need to be performed to implement this requirement? (Choose four.)

Answer options

• A. Create an external file format that would map to the parquet-based files
• B. Load the data into a staging table
• C. Create an external table called XYZ_sales_details
• D. Create an external data source for the Azure Blob storage account
• E. Create a master key on the database
• F. Configure Polybase to use the Azure Blob storage account

Correct answer: B, C, D, E

Explanation

The correct actions to take are B, C, D, and E. Loading data into a staging table (B) is essential for processing before it can be moved to the destination table. Creating an external table (C) allows for querying the data in the parquet format, while establishing an external data source (D) is necessary for connecting to the Azure Blob storage. Creating a master key (E) is a security requirement for enabling encrypted connections. Option A is not needed as the external file format is not directly referenced in the loading process, and F is incorrect as PolyBase configuration is implied after the other steps.