Exam DP-900 topic 1 question 282 discussion

Yes - The pgAdmin tool can indeed be used to manage Azure Database for PostgreSQL12345. No - Azure Database for MariaDB offers point-in-time restore, but the backup retention period can be configured up to 35 days, not 365 days67. Yes - By default, Azure Database for MySQL enforces SSL connections between your server and your client applications to protect against “man in the middle” attacks

NO NO NO Benefits of Azure Database for PostgreSQL: Users of PostgreSQL will be familiar with the pgAdmin tool, which you can use to manage and monitor a PostgreSQL database. You can continue to use this tool to connect to Azure Database for PostgreSQL. However, some server-focused functionality, such as performing server backup and restore, aren't available because the server is managed and maintained by Microsoft. https://learn.microsoft.com/en-us/training/modules/explore-provision-deploy-relational-database-offerings-azure/3-azure-database-open-source

yes no no

Correct: 1_Yes.pgAdmin is a popular open-source administration and management tool for PostgreSQL databases. While it is not directly provided or managed by Azure, you can use pgAdmin to connect to and manage Azure Database for PostgreSQL instances. 2_ No.Azure Database for MariaDB does not offer point-in-time restore for up to 365 days. Azure Database for MariaDB provides automated backups with a retention period of up to 35 days. 3_ No. Azure Database for MySQL does not always require SSL connections. While SSL connections are recommended for security reasons, they are not mandatory by default. You have the option to configure SSL/TLS encryption for connections to Azure Database for MySQL, but it is not enforced as a strict requirement.

CORRECT: YNN