Exam AZ-304 All Questions

View all questions & answers for the AZ-304 exam

Exam AZ-304 topic 3 question 6 discussion

Actual exam question from Microsoft's AZ-304

Question #: 6
Topic #: 3

You deploy Azure App Service Web Apps that connect to on-premises Microsoft SQL Server instances by using Azure ExpressRoute. You plan to migrate the
SQL Server instances to Azure.
Migration of the SQL Server instances to Azure must:
✑ Support automatic patching and version updates to SQL Server.
✑ Provide automatic backup services.
✑ Allow for high-availability of the instances.
✑ Provide a native VNET with private IP addressing.
✑ Encrypt all data in transit.
✑ Be in a single-tenant environment with dedicated underlying infrastructure (compute, storage).
You need to migrate the SQL Server instances to Azure.
Which Azure service should you use?

A. SQL Server in a Docker container running on Azure Container Instances (ACI)
B. SQL Server in Docker containers running on Azure Kubernetes Service (AKS)
C. SQL Server Infrastructure-as-a-Service (IaaS) virtual machine (VM)
D. Azure SQL Database Managed Instance
E. Azure SQL Database with elastic pools

Show Suggested Answer

Suggested Answer: D 🗳️

by H at Dec. 13, 2020, 4:34 p.m.

Comments

Submit Cancel

H

Highly Voted 4 years, 6 months ago

Correct answer

upvoted 46 times

QiangQiang

4 years, 1 month ago

No, it should be E. SQLMI doesn't support private IP address

upvoted 1 times

tita_tovenaar

3 years, 10 months ago

wrong: "SQL Managed Instance has private IP addresses in its own virtual network", ref https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/connect-application-instance#connect-inside-a-different-vnet

upvoted 9 times

...

sjai

3 years, 8 months ago

At a high level, SQL Managed Instance is a set of service components. These components are hosted on a dedicated set of isolated virtual machines that run inside the customer's virtual network subnet. These machines form a virtual cluster. https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/connectivity-architecture-overview

upvoted 9 times

...

erickim007

Highly Voted 4 years ago

the given answer is correct. Cannot have Azure SQL because it does not support VNET integration. SQL MI supports it.

upvoted 14 times

bruncili

3 years, 4 months ago

Azure SQL Database can leverage private endpoint to support VNET integration https://docs.microsoft.com/en-us/azure/virtual-network/vnet-integration-for-azure-services#private-link-and-private-endpoints

upvoted 1 times

...

jr_luciano

Most Recent 3 years, 3 months ago

Selected Answer: D

Correct answer

upvoted 1 times

...

Akakentavr

3 years, 4 months ago

The correct answer is D as one of the features related to Azure SQL Managed Instance is native Vnet integration - a native virtual network (VNet) implementation that addresses common security concerns https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

upvoted 1 times

...

c_groleau

3 years, 4 months ago

E - Azure SQL Database with elastic pools would be correct as well since it can have a private endpoint in the VNET

upvoted 1 times

TheBank

3 years ago

But its not native VNET Integration as with Azure SQL Managed Instance

upvoted 1 times

...

Eitant

3 years, 5 months ago

Selected Answer: D

Correct answer

upvoted 2 times

...

syu31svc

3 years, 8 months ago

"Support automatic patching and version updates" Answer is D for sure

upvoted 5 times

...

GuxMAN

3 years, 8 months ago

I think it's a trick question. I have been studying for the exam and I don't remember reading from Azure SQL Database MI, but I have read from Azure SQL MI, and only the above three options (A, B and C) indicate SQL Server, and the question is about the options for migrate SQL Server instances. The most reasonable option (following the observation if it is DB or Server) is C (IaaS), but this does not support automatic updates and patches. I'll see if this question will be in my close exam.

upvoted 1 times

...

SRJ11

3 years, 9 months ago

C. SQL Server Infrastructure-as-a-Service (IaaS) virtual machine (VM) Requirement - Provide a native VNET with private IP addressing. This cannot be achieved on Azure SQL. With VNET integration you can restrict only the services within that VNET can reach DB, but still they have to reach the public endpoint of the DB (xx.database.windows.net) and not to a private IP.

upvoted 1 times

examineezer

3 years, 5 months ago

This doesnt support automatic patching and version updates to SQL Server though does it?

upvoted 1 times

yyuryyucicuryyforme

3 years, 4 months ago

Azure supports automated backup and automated patching for an Azure VM with SQL Server installed. It must be either SQL Server 2014 or 2016+, and with the SQL IaaS Agent extension in full management mode. A pair of VMs with AGs can support the multiple SQL instances required. Not strictly mentioned in the question, but reasonable implication is existing on-premises SQL licensing. With Software Assurance in a migration scenario both on-premises and cloud VMs are covered for 180 days. An Azure VM as the SQL AG failover server would not require a license if used purely for business continuity. Using SQL on an Azure VM with multiple instances could be the best solution. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-backup https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-patching https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-iaas-agent-extension-automate-management I think my answer will be C.

upvoted 2 times

...

teehex

3 years, 10 months ago

D is the correct answer. Everything is in this section https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview#key-features-and-capabilities

upvoted 2 times

...

Shashprasad

3 years, 11 months ago

Answer is D , refer the link and check in that 'Key features and capabilities" , all the requirements are meet. https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

upvoted 2 times

...

Oracleist

4 years, 1 month ago

Managed Instance(Be in a single-tenant environment with dedicated underlying infrastructure (compute, storage)) read https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

upvoted 4 times

parkranger

3 years, 6 months ago

1. Single-tenant with dedicated underlying infrastructure (compute, storage). 2. Automatic patch

upvoted 1 times

...

reubems

4 years ago

Exactly, on that link you mention it appears as capabilities this: Isolated environment (VNet integration, single tenant service, dedicated compute and storage) So the right answer is Managed Instance.

upvoted 2 times

...

QiangQiang

4 years, 1 month ago

it should be E.

upvoted 1 times

...

nooranikhan

4 years, 2 months ago

You guys seem to have missed the most important part of the question " Be in a single-tenant environment with dedicated underlying infrastructure (compute, storage)" Managed instances runs on shared infrastructure. Only IAAS can allow you to choose reserved instances

upvoted 4 times

Oracleist

4 years, 1 month ago

read better https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview Key features and capabilities

upvoted 7 times

...

4tune

4 years ago

reserved instances doesn't equate to dedicated or isolated

upvoted 2 times

...

dcprice

4 years, 3 months ago

why isn't "E. Azure SQL Database with elastic pools" a valid option then?

upvoted 3 times

yaiba

4 years, 2 months ago

because of "native Vnet with private addressing". SQL Managed Instance can be injected in customer's VNet. https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

upvoted 2 times

...

glam

4 years, 4 months ago

D. Azure SQL Database Managed Instance

upvoted 3 times

...

milind8451

4 years, 4 months ago

Right ans.

upvoted 3 times

...

Load full discussion...