A company is planning to migrate an on-premises database environment to Azure. The environment consists of two databases that perform frequent cross-database queries. The migration must satisfy the following requirements:
- Minimize the administrative overhead of managing the underlying operating system and virtual machines.
- Support the execution of existing SQL Server Agent jobs.
- Support cross-database queries between the two databases.
- Ensure the databases are accessible via a private IP address within a virtual network.
Which two Azure SQL options can satisfy these requirements? (Select two.)
- Azure SQL Managed Instance General PurposeCevap
- Azure SQL Managed Instance Business CriticalCevap
- CAzure SQL Database single database
- DAzure SQL Database elastic pool
- ESQL Server on Azure Virtual Machines
Cevap
The correct options are Azure SQL Managed Instance General Purpose and Azure SQL Managed Instance Business Critical.
Azure SQL Managed Instance (both General Purpose and Business Critical tiers) provides near 100% compatibility with the latest SQL Server database engine. It includes a built-in SQL Server Agent, supports cross-database queries using three-part names, and is natively deployed within a subnet of an Azure Virtual Network (VNet) to secure access via a private IP address. As a fully managed PaaS solution, it eliminates the administrative overhead of managing the operating system and virtual machine infrastructure.
Adım Adım Çözüm
Anahtar Kavram
Selecting the appropriate Azure SQL deployment option based on compatibility requirements and management overhead.