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 comprehensive quiz questions designed to enhance your understanding and confidence. Master essential Azure concepts and strategies to excel on your test day!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

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.