PostgreSQL Certified Associate (EDB) Practice Test
Build your confidence for PostgreSQL Certified Associate (EDB). Practice the concepts, understand the answers, and strengthen your knowledge one question at a time.
Try a sample questionExam overview and details
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
Choose an answer and explore the explanation to see how practice works.
Which command produces a *logical* backup of a single database, suitable for cross-version restores?
Which directory under PGDATA holds the write-ahead log (WAL) segment files?
Which configuration parameter controls how often the checkpointer attempts a checkpoint when not triggered by WAL volume?
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?
Career Opportunities & Salary
Exam insights and study advice
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.
What this exam covers
Use the published domain weights to plan your study. Practice results do not predict your certification exam score.