BenchMark Quizzes by MDFT Pro

Select Service Tier for 60-TB Production Database

You work for MDFT Pro, a well-known training agency that has been operating for over two decades. The agency maintains an on-premises Microsoft SQL Server 2022 instance that hosts a massive 60-TB production database named TrainingArchive. This database contains historical records of all courses, student certifications, exam results, and training materials accumulated since the agency’s inception. Mark, the Cloud Migration Architect, is planning to migrate this critical database to Azure to leverage cloud scalability and reduce infrastructure costs.

You need to recommend a hosting solution for the TrainingArchive database that can accommodate its substantial 60 TB size while providing the performance and availability required for production workloads.

Which Azure SQL Database service tier should you recommend for hosting TrainingArchive?

Choose the correct answer from the options below.

Explanations for each answer:

Hyperscale is correct. Hyperscale tier supports databases up to 100 TB and is specifically designed for very large databases, making it ideal for the 60-TB database.
Business Critical is incorrect. Business Critical tier has a maximum database size of 4 TB, which is insufficient for a 60-TB database.
General Purpose is incorrect. General Purpose tier has a maximum database size of 4 TB, which cannot accommodate a 60-TB database.
Premium is incorrect. Premium is a DTU-based tier with a maximum database size of 4 TB, which is insufficient for a 60-TB database.

Learn more about the Hyperscale service tier:

Azure SQL Database Hyperscale

Practice Exam

Select Service Tier for 60-TB Production Database

Discuss this question on social media: