DP-300 Certification Practice Question #50

Question

SIMULATION
 -

You need to configure db1 to pause automatically after one hour of inactivity.

To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Accepted Answer

The question is a simulation task asking to configure db1 to auto-pause after one hour (60 minutes) of inactivity. This feature is exclusive to the **serverless compute tier** in Azure SQL Database. The configuration is done in the Azure portal: navigate to the database → **Compute + Storage** → set the **Auto-pause delay** to 60 minutes. The task mentions SSMS and the Azure portal; SSMS does not expose auto-pause settings, so the portal is the correct tool. This is a straightforward simulation with clear MS Learn documentation support.

More DP-300 practice questions