Q: 16
You ate designing a SQL database solution. The solution will include 20 databases that will be 20 GB
each and have varying usage patterns. You need to recommend a database platform to host the
databases. The solution must meet the following requirements:
• The compute resources allocated to the databases must scale dynamically.
• The solution must meet an SLA of 99.99% uptime.
• The solution must have reserved capacity.
• Compute charges must be minimized.
What should you include in the recommendation?
Options
Discussion
Seen this on a practice test, I think B fits since serverless scales compute automatically and would help with charge minimization.
I remember a similar scenario from labs. in an exam report and it was D.
C/D? Serverless is flexible but not sure it does reserved capacity. Elastic pool seems to fit the SLA and reserved part better.
Likely B. Serverless SQL Database seems like a good fit since it auto-scales compute based on demand, which helps minimize charges. I remember seeing something similar mentioned in practice tests and thought serverless would let each DB scale as needed. Not fully sure if reserved capacity is supported with serverless though, so I could be missing something there. Anyone else go this route?
Be respectful. No spam.
