DP-900 Practice Question: Identify considerations for relational data on Azure

Answer analysis

Option-by-option breakdown

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

• ✗

  It only supports the open-source community edition of PostgreSQL.

  Why it's wrong here

  This statement is incorrect because Azure Database for PostgreSQL is not restricted to only the open-source community edition. While it is built on the community edition of PostgreSQL, it also supports the Citus extension, which transforms the service into a distributed database that can scale out horizontally across multiple nodes. Additionally, other extensions such as PostGIS are supported, so the service is not limited to just the base community edition functionality.

• ✗

  It is a NoSQL database service.

  Why it's wrong here

  This is incorrect because Azure Database for PostgreSQL is a fully managed relational database service, not a NoSQL database. It uses the PostgreSQL relational engine, which organizes data into tables with predefined schemas, supports ACID transactions, and uses SQL for querying. NoSQL services like Azure Cosmos DB offer schema-less, non-relational data models, which are fundamentally different from PostgreSQL's relational model.

• ✓

  It supports read replicas to offload read traffic.

  Why this is correct

  This statement is true. Azure Database for PostgreSQL supports creating read replicas that can be used to offload read-only traffic from the primary instance. These replicas are updated asynchronously, and they can be created in the same region or even in a different region, providing options for read scaling, improved performance for read-heavy workloads, and regional availability.

• ✗

  It allows cross-database queries across multiple servers.

  Why it's wrong here

  This is incorrect because cross-database queries in Azure Database for PostgreSQL are limited to databases residing on the same server. The service does not allow queries that span across multiple independent server instances. To query data from multiple servers, you would need to use external tools, data integration pipelines, or implement application-level logic to combine the results, rather than using a native cross-server query feature.

• ✓

  It provides automated backups with point-in-time restore.

  Why this is correct

  This statement is true. Azure Database for PostgreSQL provides automated backups as a built-in feature, and these backups enable point-in-time restore. You can restore a database to any point within a configurable retention period, which helps protect against data corruption, accidental deletion, or other failures. The backup and restore capabilities are managed by the platform, reducing the operational burden on the user.

Go deeper

Related to this question