Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
A finance company plans to migrate its mission-critical on-premises OLTP workload to Azure. The single SQL Server database is 10 TB today and is projected to grow rapidly. Requirements are:
Use a fully managed PaaS offering.
Increase storage well beyond 10 TB without application downtime.
Maintain automatic backups and built-in high availability (99.99% SLA).
Integrate with Azure AD for authentication. Which Azure data platform option best meets these requirements?
Migrate the workload to a SQL Server 2022 Enterprise edition virtual machine running on Azure Virtual Machines with managed disks that can be resized on demand.
Deploy the database as an Azure SQL Database single database in the Hyperscale service tier.
Move the database to an Azure SQL Managed Instance in the Business Critical service tier.
Use an Azure SQL Database single database in the General Purpose serverless compute tier.
Azure SQL Database in the Hyperscale service tier is designed for very large relational workloads. It is a fully managed PaaS service that supports up to 100 TB per database and can grow storage transparently with no downtime because of its distributed storage architecture. Hyperscale includes automated backups, multiple high-availability replicas that deliver a 99.99 percent availability SLA, and native Azure AD authentication. Running SQL Server in an Azure VM still requires significant management effort and manual backup configuration. Azure SQL Managed Instance Business Critical provides PaaS benefits and high availability but supports a maximum of 8-16 TB and cannot grow online beyond that limit. Azure SQL Database in the General Purpose tier (whether provisioned or serverless) is limited to 4 TB, so it cannot satisfy future growth beyond 10 TB. Therefore, Azure SQL Database Hyperscale is the only option that fulfills all stated requirements.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Azure SQL Database Hyperscale?
Open an interactive chat with Bash
Why is Hyperscale better for large SQL databases over Managed Instances or Azure Virtual Machines?
Open an interactive chat with Bash
What are the benefits of integrating Azure SQL Database Hyperscale with Azure AD for authentication?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design data storage solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .