Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 1 question 28 discussion

Actual exam question from Microsoft's DP-300

Question #: 28
Topic #: 1

HOTSPOT -
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:

Show Suggested Answer

Suggested Answer:

Box 1: no extra time -
Auto Pause is not checked in the exhibit.
Note: If Auto Pause is checked the correct answer is: up to one minute
Box 2: intermittent and unpredictable
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview

by pepix74 at Aug. 24, 2021, 9:57 a.m.

Comments

Submit Cancel

jimmyzaas

Highly Voted 3 years, 9 months ago

Should be No Extra Time, screenshot shows Enable Auto Pause is unchecked.. so there is no pausing at all. On idle, server will run at min vcore setting. Second option is intermittent load as indicated by max and min vcore settings which is only available on serverless compute option.

upvoted 29 times

valente_sven1

3 years, 8 months ago

Thank you.

upvoted 1 times

...

ofzrgrz

Highly Voted 1 year, 9 months ago

This one is a DP-300 question. Yes it's real! :D

upvoted 11 times

...

Appajip

Most Recent 3 years, 3 months ago

No Extra Time

upvoted 1 times

...

Paula23

3 years, 5 months ago

Just done exam and auto pause delay was checked

upvoted 9 times

voodoo_sh

6 months, 2 weeks ago

if there is version of question where it is checked, then "up to 1 minute" applies

upvoted 1 times

...

gopal95

3 years, 6 months ago

The latency to auto-resume and auto-pause a serverless database is generally order of 1 minute to auto-resume and 1-10 minutes after the expiration of the delay period to auto-pause.

upvoted 1 times

...

Kwest

3 years, 7 months ago

Should be up to 10 mins. "The latency to auto-resume and auto-pause a serverless database is generally order of 1 minute to auto-resume and 1-10 minutes after the expiration of the delay period to auto-pause." https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview The default value for Autopause is 60 mins. In this scenario, auto-pause is not enabled -> default. After 4 hrs of inactivity, the database require "up to 10 mins" to resume operations for new activities. Azure SQL Database serverless is a compute tier that will automatically scale up or down the resources for a given database based on demand. If the workload no longer requires compute resources, the database will become “paused” and you will not be charged during the period when the database is in this state. When a connection attempt is made, the database will “resume” and become available. Resuming the database is not instantaneous.

upvoted 2 times

Natali

10 months, 3 weeks ago

If to assume that the checkbox is ticked, according to link that you provided it will take 1 min to resume the database. 10 minutes is what it takes to pause the database when 4 hours of idle happen. Dont mix these two

upvoted 1 times

...

Kwest

3 years, 6 months ago

Pls ignore. Should be No Extra Time.

upvoted 5 times

...

Aggie0702

3 years, 9 months ago

The correct answer is no extra time

upvoted 4 times

...

Mladen_66

3 years, 9 months ago

Auto-pause is not enabled in this case: The latency to auto-resume and auto-pause a serverless database is generally order of 1 minute to auto-resume and 1-10 minutes after the expiration of the delay period to auto-pause.

upvoted 9 times

...

pepix74

3 years, 10 months ago

The database resumes when activity occurs, why isn't the correct answer the first (no extra time)?

upvoted 4 times

...