Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 1

© examsnet.com

Question : 31 of 39

Marks: +1, -0

DRAG DROP

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.

Select and Place:

1. Create an external data source for Azure Blob storage.

2. Create a master key on database.

3. Enable Transparent Data Encryption.

4. Create the external table FactSalesOrderDetails.

5. Load the data to a staging table.

6. Create an external file format to map the parquet files.

2,1,6,4
1,3,5,6
1,2,4,5
6,5,1,2

Go to Question:

Prev Question

Next Question