PostgreSQL Certified Associate (EDB) Practice Test
PostgreSQL associate certification covering SQL fundamentals, database administration, backup, replication, performance tuning, and PostgreSQL extensions. Administered by EDB (EnterpriseDB). Key domains include Architecture & Installation, Backup, Replication, Security & Operations, Performance, Indexing & Query Tuning and SQL & Data Modeling.
Sample Questions
Try a few questions to see what the full exam is like.
Which configuration parameter controls the amount of memory allocated to PostgreSQL's shared cache used to hold disk blocks across all backends?
Which expression in a CREATE TABLE statement enforces that two columns combined never repeat across rows?
Logical replication is configured by which objects?
An application stores user preferences as a JSON document and needs efficient indexing plus operator support like @>, ?, ?| ?&. Which column type should be chosen?
A query repeatedly filters on lower(email). Which index makes this index-friendly?
Why This Certification Opens Doors
In the real world, a certified foundational knowledge of PostgreSQL directly translates to more reliable, secure, and performant database systems. Employers increasingly seek verifiable skills to manage critical data infrastructure. This certification demonstrates you possess the core operational knowledge to prevent common downtime incidents, implement proper security controls, and perform essential maintenance-skills that reduce risk and operational costs for any organization relying on PostgreSQL.
Exam Blueprint
Each domain is weighted to match the real certification exam, so a full practice simulation predicts your result.