MENU
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?
Suggested Answer: C
Get Premium DP-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
43 comments · newest first
PE
Peggy
11 months ago
User-defined restore points are cool, but not the best option here.
IN
Inocencia
11 months ago
I disagree, deleting the pool is not a smart move.
TE
Teri
11 months ago
Wait, can you really just pause it? Sounds too easy!
WI
William
12 months ago
Scaling down DWUs is a good idea too.
JU
Julianna
12 months ago
Definitely pause the pool when not in use!
WI
Willard
1 year ago
Creating a user-defined restore point sounds useful, but I don't see how it relates to minimizing costs during idle times.
PE
Pearlene
1 year ago
I practiced a similar question where pausing was the best option for cost savings. I feel confident about that choice here.
VA
Valentine
1 year ago
I think scaling down the DWUs might help, but it could still incur some costs. I need to double-check how that works.
AR
Arlen
1 year ago
I remember that pausing the SQL pool can save costs during idle times, but I'm not sure if it affects data integrity.
AN
Annita
1 year ago
Pausing the pool sounds like the way to go. That will stop the billing while preserving the data, which is exactly what the question is asking for.
LA
Lashawn
1 year ago
Deleting the pool is definitely not the right answer here - we need to keep the data. I'm leaning towards pausing the pool as the most cost-effective solution.
BA
Barrie
1 year ago
I'm a bit confused on the difference between scaling down the DWUs and pausing the pool. Can someone clarify the pros and cons of each option?
CO
Corrie
1 year ago
Okay, I think I know the answer here. Pausing the pool seems like the best way to minimize costs while keeping the data intact.
NO
Novella
1 year ago
Hmm, this seems like a tricky one. I'll need to think carefully about the options and how they impact the data.
TY
Ty
1 year ago
This seems a bit complex, with all the different Kubernetes resources involved. I better double-check my work to make sure I'm not missing anything. Don't want to mess this up on the exam.
SO
Solange
1 year ago
This is right in my wheelhouse! As someone who's worked in retail finance, I'm pretty confident I know the ins and outs of the pension transfer specialist training and certification. I'll breeze through this question.
AL
Alayna
1 year ago
I'm pretty sure the sequence number is used to detect losses, so I'll go with option A.
LO
Louann
1 year ago
I practiced a similar question on quality objectives, and that seemed more like their responsibility. But I'm not completely sure about the education modules part.
SA
Salena
1 year 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!
EM
Emogene
1 year ago
B) Pause the pool.
RO
Rodrigo
1 year ago
A) Scale down the data warehouse units (DWUs).
JO
Jodi
1 year ago
B) Pause the pool.
RE
Rebecka
1 year ago
A) Scale down the data warehouse units (DWUs).
VA
Vanda
1 year 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.
HA
Harrison
1 year ago
B) Pause the pool
LE
Leota
1 year ago
A) Scale down the DWUs
LE
Lettie
1 year 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.
RO
Rory
1 year ago
C) Create a user-defined restore point.
TA
Tamesha
1 year ago
B) Pause the pool.
CI
Ciara
1 year ago
A) Scale down the data warehouse units (DWUs).
DI
Dick
2 years 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.
EF
Effie
1 year ago
C) Create a user-defined restore point.
CO
Corinne
1 year ago
B) Pause the pool.
RA
Raylene
1 year ago
A) Scale down the data warehouse units (DWUs).
BE
Berry
2 years 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.
JO
Josphine
2 years ago
I agree with Christoper. Pausing the pool seems like the best option to save money.
MO
Mose
2 years 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.
YA
Yan
2 years 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.
WI
Willard
2 years ago
A) Scale down the data warehouse units (DWUs).
CH
Christoper
2 years ago
I think we should pause the pool to minimize costs during idle times.
KE
Kendra
2 years ago
I disagree. I think scaling down the data warehouse units (DWUs) would be more cost-effective in the long run.
ME
Merissa
2 years ago
I agree with Wilbert. Pausing the pool seems like the best option to save costs.
WI
Wilbert
2 years ago
I think we should pause the pool to minimize cost during idle times.