Test Index

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

© examsnet.com

Question : 30 of 39

Marks: +1, -0

DRAG DROP

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

Data in the table will be retained for five years. Once a year, data that is older than five years will be deleted.

You need to ensure that the data is distributed evenly across partitions. The solutions must minimize the amount of time required to delete old data.

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.

ROUND_ROBIN
REPLICATE
HASH
OrderDateKey
REPLICATE
SalesOrderNumber
OrderDateKey
SalesorderNumber

Go to Question:

Prev Question

Next Question