Microsoft Azure Architect Design (AZ-304) Practice Test

Disable ads (and more) with a membership for a one time $2.99 payment

Prepare for the Microsoft Azure Architect Design (AZ-304) Exam with our comprehensive resources. Engage with interactive questions, real exam scenarios, and detailed explanations tailored to enhance your understanding. Ace your exam and elevate your cloud architecture skills!

Practice this question and more.

Which Azure service should you use to migrate SQL Server instances while ensuring high availability and encryption of data in transit?

Azure SQL Database
SQL Server IaaS VM
Azure Kubernetes Service
Azure Container Instances

The correct answer is: Azure SQL Database

Using Azure SQL Database for migrating SQL Server instances promotes both high availability and encryption of data in transit, making it the most suitable choice for this scenario. Azure SQL Database is a fully managed platform as a service (PaaS) that automatically provides built-in high availability features, which means that you don't need to configure or manage availability groups manually; Microsoft handles this for you. This ensures that your database is resilient and can quickly recover in case of outages. Additionally, Azure SQL Database supports encryption of data in transit using Transport Layer Security (TLS), which is essential for protecting sensitive information during migration and ongoing operations. This means that all connections to the database are secure, minimizing the risk of data breaches during data transfer. Other options like SQL Server IaaS VM can also provide high availability and encryption but require more management and configuration efforts to set up and maintain these features. Azure Kubernetes Service and Azure Container Instances are more suitable for containerized applications and do not specifically address the needs of SQL Server migration scenarios, especially concerning high availability and structured data management required for databases.