Question 1

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?

Accepted Answer

Look at the database size (80 TB). Only Hyperscale (up to 100 TB) or IaaS can handle this. The PaaS requirement eliminates IaaS.

Question 2

What mistakes do candidates make on this AZ-305 question?

Accepted Answer

Choosing Managed Instance because it's a 'migration', but missing the critical 80 TB size constraint.

How to approach this question

Full Answer

Common mistakes

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 1

More questions from this exam