Q37 PostgreSQL Domain 2 · 25–30% of exam

Which approach reduces cost when running multiple test databases that each need their own schema but share infrastructure?

  1. A One Flexible Server per database
  2. B One Flexible Server with multiple databases (schemas) (correct answer)
  3. C One database per resource group
  4. D Use Azure SQL instead

Shortcut: A single Flexible Server instance can host multiple databases. Each database is isolated at the schema/role level. This shares compute and storage costs across multiple teams.