Examkin

Soru

Zorluk: KolayRelational 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 MachinesCevap
  2. Azure SQL Managed InstanceCevap
  3. C
    Azure SQL Database single database
  4. D
    Azure SQL Database elastic pool

Cevap

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.

Adım Adım Çözüm

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.

Anahtar Kavram

Selecting the appropriate Azure SQL relational database service based on feature compatibility and network isolation requirements.
Bu soruyu puanla

Konular

Relational Data Storage Solutions

Bu konudan daha fazla soru