DP-203 Certification Practice Question #194

Question

You have an Azure Synapse Analytics dedicated SQL pool.

You need to create a copy of the data warehouse and make the copy available for 28 days. The solution must minimize costs.

Which three 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.

Accepted Answer

To create a copy that remains available for 28 days at minimal cost, the right pattern is to create a restore point, restore that point into a new dedicated SQL pool, and then pause the restored pool. Pausing preserves the restored warehouse while avoiding ongoing compute charges, which is exactly the cost-optimization the question asks for.

More DP-203 practice questions