ExpertHard1 markMultiple Choice
Domain 2.1: Design a data storage solution for relational dataDomain 2Relational DataAzure SQLHyperscale
AZ-305 · Question 16 · Domain 2.1: Design a data storage solution for relational data
A retail enterprise is migrating a massive 80 TB on-premises SQL Server data warehouse to Azure.
The database experiences highly unpredictable workloads, requiring rapid scaling of compute resources independent of storage. The company requires a fully managed PaaS solution. They do not use any legacy SQL Server features like CLR or cross-database distributed transactions.
Which Azure SQL deployment option should you recommend?
A retail enterprise is migrating a massive 80 TB on-premises SQL Server data warehouse to Azure.
The database experiences highly unpredictable workloads, requiring rapid scaling of compute resources independent of storage. The company requires a fully managed PaaS solution. They do not use any legacy SQL Server features like CLR or cross-database distributed transactions.
Which Azure SQL deployment option should you recommend?
Answer options:
A.
Azure SQL Database Hyperscale
B.
Azure SQL Managed Instance
C.
SQL Server on Azure Virtual Machines
D.
Azure SQL Database Business Critical
How to approach this question
Look at the database size (80 TB). Only Hyperscale (up to 100 TB) or IaaS can handle this. The PaaS requirement eliminates IaaS.
Full Answer
A.Azure SQL Database Hyperscale✓ Correct
Azure SQL Database Hyperscale is the only PaaS relational database option in Azure that supports databases larger than 16 TB (up to 100 TB). Its unique architecture separates the compute engine from the storage engine, allowing compute to scale rapidly regardless of the data size. Managed Instance and Business Critical tiers have strict storage limits (16 TB and 4 TB respectively) that disqualify them for an 80 TB database.
Common mistakes
Choosing Managed Instance because it's a 'migration', but missing the critical 80 TB size constraint.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 1
55 questions · hints · full answers · grading
More questions from this exam
Q01Contoso Ltd is a global financial institution with 80 Azure subscriptions spread across 4 managem...MediumQ02Fabrikam Inc. operates a hybrid cloud environment with 500 on-premises VMware virtual machines ru...HardQ03A startup company has a single Azure subscription with a monthly budget of $5,000.
The CFO want...EasyQ04You are designing an Azure Sentinel architecture for a Managed Security Service Provider (MSSP). ...MediumQ05A healthcare enterprise is migrating its infrastructure to Azure. They have strict compliance req...Hard