# PostgreSQL Database Administration (Short) Assessment

## Description
The PostgreSQL Database Administration (Short) test is designed to measure candidates' and employees' knowledge and skills required to configure, maintain, and operate PostgreSQL database environments. It evaluates a broad range of competencies including database object creation and management, user and role administration, access control, backup and recovery procedures, performance monitoring and query optimization, routine maintenance tasks such as VACUUM and ANALYZE, and overall PostgreSQL configuration and instance management. The assessment tests understanding of key tools and techniques such as pg_dump, pg_restore, write-ahead logging, streaming and logical replication, the EXPLAIN command, system catalog tables, and pg_upgrade, among others.

The test measures skills through a variety of question formats including Multiple Choice, Multiple Correct Answer, and Essay Composition questions, with one or more questions scored using artificial intelligence. To enhance predictive performance and deter dishonesty, certain questions are subject to individual time limits, and all questions are drawn from a large pool to ensure each administration of the test presents a unique set of items.

## Competencies Measures
- Backup and Recovery
- Database Object Creation and Management
- Database Object Creation and Management (Free Text Responses)
- Performance Monitoring and Query Optimization
- User, Role, and Access Control Management
- User, Role, and Access Control Management (Free Text Responses)

## Metadata
- **Duration:** 14.0 Minutes
- **Language:** English (US)
- **Type:** Skills/Knowledge Assessment (Test)
- **Last Updated:** July 1, 2026

## Catalog Link
View additional details or to administer the assessment to a candidate here:
[View in Online Test Catalog](https://www.hravatar.com/ta/tests/9695/postgresql-database-administration-short.html)