Administering Relational Databases on Microsoft Azure — Question 59
You have an on-premises Microsoft SQL Server 2022 instance that hosts a 60-TB production database named DB1.
You plan to migrate DB1 to Azure.
You need to recommend a hosting solution for DB1.
Which Azure SQL Database service tier should you use to host DB1?
Answer options
- A. Hyperscale
- B. Business Critical
- C. General Purpose
Correct answer: A
Explanation
The Hyperscale tier is designed to accommodate large databases, such as DB1 with its 60-TB size, offering scalability and performance. The Business Critical tier is suited for smaller databases requiring high availability, and the General Purpose tier lacks the necessary storage capacity and performance features needed for such a large database.