BenchMark Quizzes by MDFT Pro

Select Service Tier For Serverless Compute

You work for MDFT Pro, a well-known training agency planning to migrate five databases from a Microsoft SQL Server 2017 server to Azure. Mark, the Service Tier Selection Specialist, is evaluating different Azure SQL Database service tiers to find the optimal configuration. The databases support various training operations including StudentEnrollment, CourseMaterials, AssessmentResults, TrainerAvailability, and CertificationTracking. Each database has different usage patterns with varying levels of activity throughout the day. Mark wants a solution that automatically scales compute resources based on workload demand to ensure good performance during busy periods while reducing costs during quiet times, and provides per-second billing to minimize costs by only charging for actual compute consumption rather than reserved capacity.

Which service tier should you include in the recommendation?

Choose the correct answer from the options below.

Explanations for each answer:

The Basic service tier is incorrect. The Basic tier is a DTU-based tier that doesn't support serverless compute or automatic scaling.
The General Purpose service tier is correct. The General Purpose service tier supports the serverless compute tier which provides automatic scaling and per-second billing.
The Standard service tier is incorrect. The Standard tier is a DTU-based tier that doesn't support serverless compute or per-second billing.
The Premium service tier is incorrect. The Premium tier is a DTU-based tier that doesn't support serverless compute, though it provides high performance.

Learn more about Serverless Compute Tiers:

Azure SQL Database Serverless

Practice Exam

Select Service Tier For Serverless Compute

Discuss this question on social media: