DP-300 · Question #137
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 correct answer is Create a master key on database.; Create an external data source for Azure Blob storage.; Create an external file format to map the parquet files.; Create the external table FactSalesOrderDetails. 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…
Question
Exhibit
Answer Area
Drag items
Correct arrangement
- Create a master key on database.
- Create an external data source for Azure Blob storage.
- Create an external file format to map the parquet files.
- Create the external table FactSalesOrderDetails.
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.
Topics
Community Discussion
No community discussion yet for this question.