Examkin

Question

Difficulty: MediumRelational Data Storage Solutions

A company is planning to migrate an on-premises SQL Server database to Azure. The database requires the use of SQL Server Agent to run scheduled maintenance tasks and relies on cross-database queries. The migration solution must also support automatic database backups with a retention period of up to 10 years.

Which two Azure SQL deployment options support these requirements? (Select two.)

  1. Azure SQL Managed InstanceAnswer
  2. SQL Server on Azure Virtual MachinesAnswer
  3. C
    Azure SQL Database (single database)
  4. D
    Azure SQL Database (elastic pool)

Answer

Azure SQL Managed Instance and SQL Server on Azure Virtual Machines
Azure SQL Managed Instance and SQL Server on Azure Virtual Machines are the deployment options that support instance-level features like SQL Server Agent and cross-database queries. Both options also support backing up databases with long-term retention up to 10 years.

Step-by-Step Solution

1
Identify the legacy feature requirements in the scenario.
The database requires SQL Server Agent and cross-database queries.
These requirements narrow the choice to deployment options that provide instance-level capabilities.
2
Evaluate the Azure SQL deployment options against the identified legacy requirements.
Azure SQL Managed Instance and SQL Server on Azure Virtual Machines support both SQL Server Agent and cross-database queries natively. Azure SQL Database (single database and elastic pools) does not natively support these features.
Azure SQL Database is a database-level service, whereas SQL Server Agent and cross-database queries require instance-level features.
3
Verify backup retention requirements for the compatible deployment options.
Both Azure SQL Managed Instance (via Long-Term Retention) and SQL Server on Azure Virtual Machines (via Azure Backup for SQL Server) support automated backups with up to 10 years of retention.
This step confirms both options fully satisfy all functional and recovery constraints.

Key Concept

Azure SQL Deployment Options Feature Compatibility
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic