Microsoft Certified Azure Data Fundamentals · Free Practice Question Easy

Question 1

Which of the following Azure SQL options allows you to run your own full version of SQL Server with full control over the operating system?
  • A SQL Server on Azure Virtual Machines
  • B Azure SQL Database
  • C Azure SQL Edge
  • D Azure SQL Managed Instance
Reveal correct answer

Correct answer: A

A. SQL Server on Azure Virtual Machines allows you to run your own full version of SQL Server with full control over the operating system. It provides the flexibility to customize the virtual machine configuration, install any software, and have complete control over the SQL Server instance running on the virtual machine.

B. Azure SQL Database is a fully managed database service that does not provide full control over the operating system. It is a platform as a service (PaaS) offering where Microsoft manages the infrastructure, patching, and backups for you.

C. Azure SQL Edge is a containerized database engine designed for IoT and edge computing scenarios. It is optimized for low latency and offline capabilities but does not provide the ability to run your own full version of SQL Server with full control over the operating system.

D. Azure SQL Managed Instance is a platform as a service (PaaS) offering that provides a fully managed SQL Server instance, but it does not allow full control over the operating system. It is designed to be a fully managed service with high compatibility with SQL Server.

Discussion

Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.

You must be logged in to post a comment.

Preparing For

Your Certification?

255+ certifications
Detailed explanations
Free PDF samples

Has All The Questions You Need