ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 1 question 28 discussion

Actual exam question from Microsoft's DP-300
Question #: 28
Topic #: 1
[All DP-300 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
jimmyzaas
Highly Voted 3 years, 8 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, 7 months ago
Thank you.
upvoted 1 times
...
...
ofzrgrz
Highly Voted 1 year, 8 months ago
This one is a DP-300 question. Yes it's real! :D
upvoted 10 times
...
Appajip
Most Recent 3 years, 1 month ago
No Extra Time
upvoted 1 times
...
Paula23
3 years, 4 months ago
Just done exam and auto pause delay was checked
upvoted 9 times
voodoo_sh
4 months, 4 weeks ago
if there is version of question where it is checked, then "up to 1 minute" applies
upvoted 1 times
...
...
gopal95
3 years, 4 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, 5 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
9 months, 1 week 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, 5 months ago
Pls ignore. Should be No Extra Time.
upvoted 5 times
...
...
Aggie0702
3 years, 7 months ago
The correct answer is no extra time
upvoted 4 times
...
Mladen_66
3 years, 8 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, 8 months ago
The database resumes when activity occurs, why isn't the correct answer the first (no extra time)?
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago