Data Engineering on Microsoft Azure DP-203 Practice Test 1

© examsnet.com

Question : 19 of 20

Marks: +1, -0

You have a SQL pool in Azure Synapse.

You plan to load data from Azure Blob storage to a staging table. Approximately 1 million rows of data will be loaded daily. The table will be truncated before each daily load.

You need to create the staging table. The solution must minimize how long it takes to load the data to the staging table.

How should you configure the table? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Distribution ______
Hash
Replicated
Round-robin
Indexing ______
Clustered
Clustered columnstore
Heap
Partitioning ______
Date
None

Go to Question:

Advertisements