Microsoft Azure Data Fundamentals — Question 102

You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.
You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact.
What should you do on the dedicated SQL pool?

Answer options

• A. Scale down the data warehouse units (DWUs).
• B. Pause the pool.
• C. Create a user-defined restore point.
• D. Delete the pool

Correct answer: B

Explanation

The correct answer is B, as pausing the dedicated SQL pool suspends the compute resources, significantly lowering costs while keeping the data intact. Option A, scaling down the DWUs, would still incur costs as resources remain active. Option C, creating a restore point, does not affect costs and is irrelevant to the objective of minimizing expenses during idle times. Option D, deleting the pool, would result in data loss.