Courseiva
Describe Azure architecture and servicesmediumMultiple ChoiceObjective-mapped

AZ-900 Describe Azure architecture and services Practice Question

Which Azure database service provides a fully managed MariaDB database in the cloud?

⚠ Common exam trap

It's easy for candidates to confuse MariaDB with MySQL due to their shared history and wire compatibility, leading them to incorrectly select Azure Database for MySQL instead of the dedicated Azure Database for MariaDB service.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

Azure Database for MariaDB

Azure Database for MariaDB is the correct answer because it is the specific Azure service designed to provide a fully managed, enterprise-ready MariaDB database in the cloud. MariaDB is a community-developed fork of MySQL, and Azure offers a dedicated managed service for it, including built-in high availability, automated backups, and scaling, without requiring you to manage the underlying infrastructure.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Azure Database for MySQL

    Why it's wrong here

    Azure Database for MySQL is a managed relational database service that specifically runs the MySQL Community Edition engine. Although MariaDB originally forked from MySQL, the two have evolved independently with meaningful differences in storage engines, optimization, and compatibility, so Azure offers separate managed services for each. Deploying a MariaDB workload to this service would expose MySQL-specific behavior and is not the intended target for MariaDB.

  • Azure Database for MariaDB

    Why this is correct

    Azure Database for MariaDB is the correct choice because it is Azure's fully managed relational database service purpose-built for MariaDB databases. It provides built-in high availability, automated backups, automatic patching, and horizontal scaling via read replicas while ensuring compatibility with MariaDB's query language and storage engines. This is the service that directly maps to a MariaDB workload.

  • Azure SQL Database

    Why it's wrong here

    Azure SQL Database is a managed platform-as-a-service database built on the Microsoft SQL Server engine, with features such as SQL Server integration, T-SQL dialect, and SQL Server authentication. It does not support the MariaDB wire protocol, client libraries, or particularly the InnoDB and Aria storage engines, so migrating a MariaDB database to Azure SQL Database would require a full schema and application rewrite. It is therefore not the appropriate service for a MariaDB workload.

  • Azure Database for PostgreSQL

    Why it's wrong here

    Azure Database for PostgreSQL is a managed relational database service that runs the PostgreSQL engine, which differs fundamentally from MariaDB in SQL conformance, object-relational features, and extension ecosystem. PostgreSQL uses a separate wire protocol and client libraries, so it cannot directly accept MariaDB connections or execute MariaDB-specific SQL. Since Azure provides a distinct managed offering for MariaDB, choosing PostgreSQL would be incorrect.

About these practice questions

Courseiva writes every AZ-900 question from scratch — 981 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This AZ-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AZ-900 exam.