DP-300 Question #137: Real Exam Question with Answer & Explanation

Question

Drag and Drop Question You are creating a managed data warehouse solution on Microsoft Azure. You must use PolyBase to retrieve data from Azure Blob storage that resides in parquet format and load the data into a large table called FactSalesOrderDetails. You need to configure Azure Synapse Analytics to receive the data. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Answer:

Explanation

The correct sequence follows the mandatory dependency chain for PolyBase configuration in Azure Synapse Analytics: First, a master key must be created to protect the database-scoped credential used for authentication. Next, an external data source is created to point PolyBase to the Azure Blob storage location. Then, an external file format must be defined to tell PolyBase how to interpret the parquet files. Finally, the external table FactSalesOrderDetails is created, referencing both the data source and file format to expose the data as a queryable object - at which point data can be loaded using INSERT INTO...SELECT or CTAS patterns.

No community discussion yet for this question.