Q44 PostgreSQL Domain 2 · 25–30% of exam

An application uses Azure AD tokens to authenticate to Flexible Server. What must be configured on the server?

  1. A Enable password authentication only
  2. B Enable Microsoft Entra authentication and assign the client identity a PostgreSQL role (correct answer)
  3. C Configure SSL certificates
  4. D Enable Public Key Infrastructure (PKI)

Shortcut: Enable Entra authentication in Flexible Server settings. Create a PostgreSQL role matching the managed identity or service principal, then grant it the appropriate database permissions.