Drag and Drop Question Match the Azure SQL services to the appropriate use cases. To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may…

The correct answer is Azure SQL Database single database; Azure SQL Managed instance; Azure SQL Database elastic pool. Azure SQL Database single database is ideal for a single, isolated database with its own dedicated resources and predictable performance requirements. Azure SQL Managed Instance is the best fit for lift-and-shift migrations from on-premises SQL Server, as it provides near 100%…

Submitted by fatema_kw· Mar 30, 2026Describe Azure database and analytics services / Core Azure Services

Question

Drag and Drop Question Match the Azure SQL services to the appropriate use cases. To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Answer:

Exhibit

Answer Area

Drag items

Azure SQL Database elastic poolAzure SQL Database single databaseAzure SQL Managed instance

Correct arrangement

Azure SQL Database single database
Azure SQL Managed instance
Azure SQL Database elastic pool

Explanation

Azure SQL Database single database is ideal for a single, isolated database with its own dedicated resources and predictable performance requirements. Azure SQL Managed Instance is the best fit for lift-and-shift migrations from on-premises SQL Server, as it provides near 100% compatibility with the SQL Server engine, including features like SQL Agent, cross-database queries, and CLR. Azure SQL Database elastic pool is designed for managing and scaling multiple databases that have variable, unpredictable usage patterns, allowing them to share a pool of resources cost-effectively.

Topics

#Azure SQL#PaaS Databases#SQL Managed Instance#Elastic Pools

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice