ExpertHard1 markMultiple Choice
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?
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
Azure SQL Managed Instance
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.
Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 7
55 questions · hints · full answers · grading
More questions from this exam
Q01CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...HardQ02CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...MediumQ03CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...HardQ04CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...MediumQ05CASE STUDY: Contoso migrating 500 servers to Azure. RTO 2h, RPO 15m, GDPR compliance, 10Gbps Expr...Hard