DP-300 Certification Practice Question #18

Question

You are provisioning an Azure SQL database in the Azure portal as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

In the database configuration screenshot, the "Enable auto-pause" checkbox is left unchecked, meaning the serverless database will not pause even during long periods of inactivity; it will continue to run at the minimum compute limit of 0.75 vCores. As a result, no extra time is required to resume operations when activity returns. Additionally, the serverless tier (even without auto-pause) optimizes costs by dynamically scaling compute between min and max vCores to match demand, which is ideal for workloads with intermittent and unpredictable usage patterns.

More DP-300 practice questions