DP-300 Certification Practice Question #143

Question

You have an Azure subscription that contains the resources shown in the following table.

App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity.

You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs.

What should you do?

Accepted Answer

The scenario shows db1 is an Azure SQL database in the **serverless tier** (confirmed by the image: "Azure SQL database in the serverless tier"). App1 experiences transient connection errors after **extended inactivity** — the classic symptom of auto-pause resumption latency, which causes error 40613. The question asks to resolve this "as soon as possible, without considering immediate costs." Disabling auto-pause (D) eliminates the root cause entirely: the database stays online continuously, so no cold-start latency or error 40613 occurs. Decreasing the delay (C) would actually cause more frequent pauses and more errors. Increasing vCores or enabling automatic tuning do not address connectivity issues from pausing.

More DP-300 practice questions