Examkin

Question

Difficulty: EasyRelational Data Storage Solutions

A company is designing a new relational database solution in Azure. The database has the following requirements:

* Must support SQL Server Agent for scheduling internal database maintenance tasks.
* Must be deployed with a private IP address within an Azure Virtual Network (VNet).

Which two Azure SQL deployment options meet these requirements?

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

Answer

SQL Server on Azure Virtual Machines and Azure SQL Managed Instance
SQL Server on Azure Virtual Machines and Azure SQL Managed Instance both natively support SQL Server Agent. Additionally, both options are deployed directly within an Azure Virtual Network, giving them private IP addresses by default.

Step-by-Step Solution

1
Identify the requirement for SQL Server Agent support.
Only SQL Server on Azure Virtual Machines and Azure SQL Managed Instance support this feature natively.
Azure SQL Database single database and elastic pools do not support SQL Server Agent natively.
2
Identify the requirement for private IP address deployment within a VNet.
Both SQL Server on Azure Virtual Machines and Azure SQL Managed Instance are deployed inside an Azure Virtual Network.
Azure SQL Database single database and elastic pools are logical services hosted on public endpoints by default.

Key Concept

Selecting the appropriate Azure SQL relational database service based on feature compatibility and network isolation requirements.
Rate this question

Topics

Relational Data Storage Solutions

More questions from this topic