Data Engineering on Microsoft Azure DP-203 Practice Test 1

© examsnet.com

Question : 11 of 20

Marks: +1, -0

You need to create a partitioned table in an Azure Synapse Analytics dedicated SQL pool.

How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Select and Place:

```
CLUSTERED INDEX 
 COLLATE 
```
```
PARTITION FUNCTION 
  PARTITION SCHEME
```
```
DISTRIBUTION  
 PARTITION 
```
```
DISTRIBUTION  
 PARTITION SCHEME
```
```
 PARTITION   
 DISTRIBUTION
```
```
PARTITION   
 COLLATE 
```

Go to Question:

Advertisements