A company plans to migrate an on-premises database environment to Azure. The environment contains multiple databases that require the execution of native cross-database queries using three-part names. In addition, the databases rely heavily on SQL Server Agent for scheduled ETL processes.
Which two database options should you recommend to support this migration? (Select two.)
- Azure SQL Managed InstanceAnswer
- SQL Server on Azure Virtual MachinesAnswer
- CAzure SQL Database single database
- DAzure SQL Database elastic pool
Answer
Azure SQL Managed Instance and SQL Server on Azure Virtual Machines are the correct options.
Azure SQL Managed Instance and SQL Server on Azure Virtual Machines both support SQL Server Agent and native cross-database queries using three-part names because they provide instance-level SQL Server features. Managed Instance offers these capabilities with the benefits of a fully managed service (PaaS), while SQL Server on Azure VMs provides a complete SQL Server environment in an infrastructure-as-a-service (IaaS) model.
Step-by-Step Solution
Key Concept
Instance-level vs. database-level feature compatibility in Azure SQL options
Estimated Time:2m 0s