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.
Explanation
PolyBase reaches external data through objects defined in the database, and each one depends on the one before it. The master key comes first because it encrypts the credential secret used to access storage. Next you define the external data source that points to Blob storage and the external file format that describes the parquet files, and the external table then binds its columns to that location and format. Transparent Data Encryption is unrelated to PolyBase access, and loading into a staging table is a later step that uses the external table rather than part of configuring it.
