nerdexam
Microsoft

DP-900 · Question #7

You are working in an organization and your client wants to migrate all of his SQL workloads to the Azure such that complete SQL Server compatibility and operating system-level access will be…

The correct answer is D. SQL Server on Virtual Machines. SQL Server for Virtual Machines Azure database is responsible to migrate the SQL workloads on Azure while maintaining the operating system-level access and SQL Server compatibility. So, in the given scenario, SQL Server on Virtual Machines will be the right choice. Option A is…

Submitted by certguy· Mar 30, 2026Identify considerations for relational data on Azure

Question

You are working in an organization and your client wants to migrate all of his SQL workloads to the Azure such that complete SQL Server compatibility and operating system-level access will be maintained. Which Azure Database would you recommend to the client?

Options

  • AAzure SQL Database
  • BAzure Cosmo DB
  • CAzure SQL Managed Instance
  • DSQL Server on Virtual Machines

How the community answered

(37 responses)
  • A
    5% (2)
  • B
    3% (1)
  • C
    16% (6)
  • D
    76% (28)

Explanation

SQL Server for Virtual Machines Azure database is responsible to migrate the SQL workloads on Azure while maintaining the operating system-level access and SQL Server compatibility. So, in the given scenario, SQL Server on Virtual Machines will be the right choice. Option A is incorrect. Azure SQL Database is an up-to-date relational database service with hyper scale storage, serverless compute, automated, and AI-powered features for the optimization of durability and performance. Option B is incorrect. Azure SQL Managed Instance enables the migration of SQL workloads to Azure and maintains SQL Server Compatibility with the benefits of an evergreen, fully managed Option C is incorrect. Azure Cosmos DB enables building applications with high availability and low latency, at any scale, and anywhere. It also enables the migration of MongoDB, Cassandra, and other NoSQL workloads to the cloud. Option D is correct. SQL Server for Virtual Machines Azure database is responsible to migrate the SQL workloads on Azure while maintaining the operating system-level access and SQL Server compatibility. https://azure.microsoft.com/en-in/product-categories/databases/

Topics

#SQL Server on VM#IaaS#OS-level access#migration

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice