For Individuals For Educators

Ace your certifications with Practice Exams and AI assistance.

Browse Exams
For Educators
Blog

Privacy Policy
Terms of Service
Cookie Policy
Support

AWS SAA Exam Prep
PMI PMP Exam Prep
CPA Exam Prep
GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

Practice Azure Solutions Architect Expert (AZ-305)Azure Solutions Architect Expert AZ-305 Practice Exam 7Question 20

Hard1 markMultiple Choice

Domain 2.1: Relational DataDatabaseMigration

AZ-305 · Question 20 · Domain 2.1: Relational Data

You are migrating an on-premises SQL Server database to Azure. The application relies heavily on SQL Server Agent jobs, cross-database queries, and CLR integration. You need a PaaS solution with native VNet integration. Which service should you choose?

Answer options:

A.

Azure SQL Managed Instance

B.

Azure SQL Database

C.

SQL Server on Azure VMs

D.

Azure Synapse Analytics

How to approach this question

Match legacy SQL features with the correct PaaS offering.

Full Answer

A.Azure SQL Managed Instance✓ Correct

SQL Managed Instance provides near 100% compatibility with on-prem SQL Server while remaining a PaaS service. Pillar: Reliability.

Common mistakes

Choosing Azure SQL Database which lacks instance-level features.

Question 19 All questions Question 21

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 7

55 questions · hints · full answers · grading

Sign up free Take the exam

More questions from this exam

Q01CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...Hard Q02CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...Medium Q03CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...Hard Q04CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...Medium Q05CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...Hard

View all 55 questions →