Examkin

Question

Difficulty: HardRelational Data Storage Solutions

An organization plans to migrate an on-premises ERP application and its SQL Server database to Azure. The migration must meet the following requirements:
- Support SQL Server Agent jobs for internal database maintenance.
- Enable cross-database queries between databases hosted on the same instance.
- Minimize administrative effort for database host patching, operating system management, and backups.
- Provide automatic failover to a secondary Azure region with a single write listener endpoint in the event of a regional outage.

Which two technologies should you recommend to meet these requirements? (Select two.)

  1. Azure SQL Managed InstanceAnswer
  2. Failover groupsAnswer
  3. C
    Azure SQL Database elastic pools
  4. D
    SQL Server on Azure Virtual Machines
  5. E
    Active geo-replication

Answer

Azure SQL Managed Instance and Failover groups
Azure SQL Managed Instance provides the required native SQL Server Agent and cross-database query support within a fully managed PaaS framework, minimizing administrative overhead. Failover groups provide the replication and automatic failover mechanism to a secondary region while presenting a single connection listener endpoint to client applications.

Step-by-Step Solution

1
Analyze database compatibility requirements.
SQL Server Agent and cross-database queries are required. This rules out Azure SQL Database single database and elastic pool options, pointing to SQL Server on Azure VM or Azure SQL Managed Instance.
Azure SQL Database single database options do not natively support SQL Server Agent or cross-database queries.
2
Analyze administrative overhead constraints.
SQL Server on Azure VM is ruled out because it requires managing OS patching, virtual machines, and backup agents.
Azure SQL Managed Instance is a PaaS service that minimizes host management and patching effort while retaining legacy compatibility features.
3
Determine the regional failover and connectivity architecture.
Failover groups are selected to manage geo-replication and automatic failover with a single connection listener.
Failover groups provide automatic group failover and DNS listener redirection across Azure SQL Managed Instances in different regions.

Key Concept

Selecting and configuring Relational Data Storage Solutions in Azure based on compatibility, management overhead, and regional failover requirements.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic