azure, Databases, DP-900, Microsoft Certification

Practice Questions: Identify Azure Database Services for open-source database systems (DP-900 Exam Prep)

Practice Questions

Question 1

Which Azure service is used to host a managed PostgreSQL database?

A. Azure SQL Database
B. Azure Database for PostgreSQL
C. Azure Cosmos DB
D. Azure Synapse Analytics

✅ Answer: B

Explanation:
Azure Database for PostgreSQL is the managed service for PostgreSQL workloads.

Question 2

Which Azure service is BEST suited for hosting a MySQL-based web application?

A. Azure SQL Managed Instance
B. Azure Database for MySQL
C. Azure Data Lake Storage
D. Azure Blob Storage

✅ Answer: B

Explanation:
Azure Database for MySQL is designed for MySQL workloads, commonly used in web apps.

Question 3

What type of service are Azure Database for PostgreSQL and Azure Database for MySQL?

A. Infrastructure as a Service (IaaS)
B. Platform as a Service (PaaS)
C. Software as a Service (SaaS)
D. On-premises solutions

✅ Answer: B

Explanation:
These services are PaaS offerings, meaning Azure manages infrastructure and maintenance.

Question 4

Which task is handled by Azure in open-source database PaaS services?

A. Writing SQL queries
B. Managing application code
C. Performing backups and patching
D. Designing database schema

✅ Answer: C

Explanation:
Azure handles operational tasks like backups, patching, and updates.

Question 5

Which scenario is BEST suited for Azure Database for PostgreSQL?

A. Running a NoSQL database
B. Migrating an existing PostgreSQL application to Azure
C. Storing unstructured files
D. Running machine learning models

✅ Answer: B

Explanation:
This service is ideal for migrating or running PostgreSQL workloads in Azure.

Question 6

Which of the following is an open-source relational database supported by Azure?

A. Microsoft SQL Server
B. Oracle Database
C. PostgreSQL
D. Azure Cosmos DB

✅ Answer: C

Explanation:
PostgreSQL is a widely used open-source relational database supported by Azure.

Question 7

Which Azure database service for open-source systems is being retired?

A. Azure Database for PostgreSQL
B. Azure Database for MySQL
C. Azure Database for MariaDB
D. Azure SQL Database

✅ Answer: C

Explanation:
Azure Database for MariaDB is being phased out.

Question 8

Which feature is commonly provided by Azure open-source database services?

A. Manual scaling only
B. No security features
C. Built-in high availability
D. No backup support

✅ Answer: C

Explanation:
These services include built-in high availability and redundancy.

Question 9

Which is a key benefit of using Azure Database for MySQL instead of installing MySQL on a VM?

A. Full OS control
B. Reduced management overhead
C. No support for scaling
D. Limited security features

✅ Answer: B

Explanation:
PaaS reduces administrative tasks like maintenance and patching.

Question 10

Which factor is MOST important when choosing Azure Database for PostgreSQL or MySQL?

A. Whether the data is unstructured
B. The need for OS-level access
C. The existing database engine used by the application
D. The need for NoSQL capabilities

✅ Answer: C

Explanation:
Choice is typically driven by the database engine already used (PostgreSQL vs MySQL).

✅ Quick Exam Takeaways

✔ Azure Database for PostgreSQL → PostgreSQL workloads
✔ Azure Database for MySQL → MySQL workloads
✔ Both are PaaS services (Azure manages infrastructure)

✔ Key benefits:

  • Automated backups
  • Patching and updates
  • High availability
  • Scalability

✔ Use when:

  • Migrating open-source databases
  • Building apps on PostgreSQL or MySQL

✔ Be aware:

  • MariaDB is being retired

Go to the DP-900 Exam Prep Hub main page.

Leave a comment