Which authentication method is recommended for Azure Database for PostgreSQL Flexible Server in production?
- A Username/password only
- B Microsoft Entra ID (AAD) authentication with managed identity (correct answer)
- C Server admin account
- D MD5 password hash
Shortcut: Entra ID authentication allows Azure managed identities and service principals to authenticate without passwords. Assign the identity the right PostgreSQL role to grant access.