ExpertEasy1 markMultiple Choice
Domain 2.1: Design a data storage solution for relational dataDomain 2Relational DataSQL ServerMigration
AZ-305 · Question 19 · Domain 2.1: Design a data storage solution for relational data
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?
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?
Answer options:
A.
SQL Server on Azure Virtual Machines
B.
Azure SQL Managed Instance
C.
Azure SQL Database
D.
Azure Synapse Analytics
How to approach this question
Identify legacy/OS-level dependencies (SSRS, SSAS, MSDTC). These almost always dictate an IaaS (Virtual Machine) migration strategy to avoid refactoring.
Full Answer
A.SQL Server on Azure Virtual Machines✓ Correct
When an application relies on OS-level components like MSDTC, or requires the full SQL Server BI stack (SSRS, SSAS, SSIS) running on the same server, SQL Server on Azure Virtual Machines (IaaS) is the only target that provides 100% compatibility without requiring a redesign. Azure SQL Database and Managed Instance are database engines only and do not host SSRS or SSAS.
Common mistakes
Choosing Managed Instance. While MI is great for 'lift and shift' of the database engine, it does not include the BI stack (SSRS/SSAS).
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