In my opinion it should be General Purpose Serverless as you can configure max and min vCores and configure Pause to save costs. So D Serverless seems the most appropriate option.
Ok hear me out. The question is:
Based on the PaaS prototype, which Azure SQL Database compute tier should you use? it does not ask which service tier. There are 2 different compute tiers: Provisioned and Serverless. While the provisioned compute tier provides a specific amount of compute resources that are continuously provisioned independent of workload activity, the serverless compute tier auto-scales compute resources based on workload activity.
The answer is clearly serverless unless whoever wrote this question does not know the difference between service tier and compute tier.
Thank you for listening!
D - Serverless - Here's why:
Serverless is optimal when there are variable workloads, which seems to be the case based on the graphs that show intermittent usage spikes. Serverless compute automatically scales resources based on usage and pauses during idle periods, helping to optimize cost and resource allocation for databases that experience irregular load patterns.
The other tiers (Business Critical, Hyperscale, and General Purpose) are more suited for workloads that have consistent or high resource demands but may not fit well in scenarios with fluctuating demand, as seen in the usage chart.
This question is either confusing or misleading due to the scenario in the case study. But definitely it is an interesting question since it checks how deep we understand the difference between the service tier / computer tier and their capabilities.
The question is which compute tier should you use.
The Business requirement says - The PaaS solution must provide automatic failover during Azure regional outage.
Serverless compute tier comes under Gen. Purpose Service tier which has HA solution where failover happens automatically during node failure or outage.
The answer is D
In the event of an Azure regional outage, ensure that the customers can access the PaaS solution with minimal downtime. The solution must provide automatic failover.
Should be "A", Always On Availability Group and Geo replication are needed.
https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla
https://docs.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview
Its a poorly written question and quite ambiguous, but just because it is "based on the PaaS prototype" it doesnt mean you ignore the business goals, and this is to provide automatic failover and protect from regional outage, hence "A"
There are daily spikes in CPU usage.
Hyperscale with automatic scaling seems the most appropriate solution.
https://techcommunity.microsoft.com/t5/azure-sql/autoscaling-azure-sql-hyperscale/ba-p/1149025
upvoted 1 times
...
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
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.
hydrillo
Highly Voted 4 years, 1 month agoTheDataGuy
Highly Voted 2 years, 4 months agobingomutant
Most Recent 7 months agoItsalwaymethecap
2 years, 10 months agoAlCubeHead
3 years, 2 months agoxegiwo9758
3 years, 4 months agobc5468521
3 years, 10 months agoKNG
3 years, 11 months agogills
3 years, 11 months agoU_C
4 years, 1 month agoSTH
3 years, 10 months agoSQLDev0000
3 years, 9 months agoRaffer
4 years, 1 month ago