Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft Exam DP-900 Topic 11 Question 80 Discussion

Actual exam question for Microsoft's DP-900 exam
Question #: 80
Topic #: 11
[All DP-900 Questions]

You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.

You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data

remains intact.

What should you do on the SQL pool?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Yan at May 01, 2024, 05:56 PM

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Salena
1 months ago
Pause the pool? More like 'pause the party' for those idle hours. But hey, at least you'll be saving some cash in the process. It's a win-win, right? Cha-ching!
upvoted 0 times
Rebecka
3 days ago
A) Scale down the data warehouse units (DWUs).
upvoted 0 times
...
...
Vanda
1 months ago
A) Scale down the DWUs - Not a bad idea, but it doesn't really address the 'idle time' problem. You'd still be paying for the compute resources, just at a lower level. Pausing the pool is definitely the way to go here.
upvoted 0 times
Harrison
7 days ago
B) Pause the pool
upvoted 0 times
...
Leota
20 days ago
A) Scale down the DWUs
upvoted 0 times
...
...
Lettie
2 months ago
D) Delete the pool? Seriously? That's like throwing the baby out with the bathwater. I'm pretty sure the question said the data needs to remain intact, and deleting the pool would just be a waste of time and effort.
upvoted 0 times
Rory
23 days ago
C) Create a user-defined restore point.
upvoted 0 times
...
Tamesha
25 days ago
B) Pause the pool.
upvoted 0 times
...
Ciara
1 months ago
A) Scale down the data warehouse units (DWUs).
upvoted 0 times
...
...
Dick
2 months ago
I'm torn between B and C. Pausing the pool is the easiest, but creating a user-defined restore point could be handy if you need to quickly restore the pool later. Hmm, decisions, decisions.
upvoted 0 times
Effie
1 months ago
C) Create a user-defined restore point.
upvoted 0 times
...
Corinne
1 months ago
B) Pause the pool.
upvoted 0 times
...
Raylene
1 months ago
A) Scale down the data warehouse units (DWUs).
upvoted 0 times
...
...
Berry
2 months ago
I think scaling down the data warehouse units could also be a good option to consider. It might help in reducing costs while keeping the data intact.
upvoted 0 times
...
Josphine
2 months ago
I agree with Christoper. Pausing the pool seems like the best option to save money.
upvoted 0 times
...
Mose
2 months ago
B) Pause the pool - This is the most obvious choice. Pausing the pool will stop the compute resources and reduce the cost during idle times. The data will remain intact, and you can resume the pool when needed.
upvoted 0 times
Yan
2 months ago
B) Pause the pool - This is the most obvious choice. Pausing the pool will stop the compute resources and reduce the cost during idle times. The data will remain intact, and you can resume the pool when needed.
upvoted 0 times
...
Willard
2 months ago
A) Scale down the data warehouse units (DWUs).
upvoted 0 times
...
...
Christoper
2 months ago
I think we should pause the pool to minimize costs during idle times.
upvoted 0 times
...
Kendra
2 months ago
I disagree. I think scaling down the data warehouse units (DWUs) would be more cost-effective in the long run.
upvoted 0 times
...
Merissa
2 months ago
I agree with Wilbert. Pausing the pool seems like the best option to save costs.
upvoted 0 times
...
Wilbert
3 months ago
I think we should pause the pool to minimize cost during idle times.
upvoted 0 times
...

Save Cancel