Question 1

You are assessing an on-premises SQL Server 2014 database for migration to Azure.

The application relies heavily on SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and cross-database distributed transactions using Microsoft Distributed Transaction Coordinator (MSDTC). The company wants to minimize code changes during the migration.

Which target architecture should you recommend?

Accepted Answer

Identify legacy/OS-level dependencies (SSRS, SSAS, MSDTC). These almost always dictate an IaaS (Virtual Machine) migration strategy to avoid refactoring.

Question 2

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

Accepted Answer

Choosing Managed Instance. While MI is great for 'lift and shift' of the database engine, it does not include the BI stack (SSRS/SSAS).

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