PostgreSQL Backup and Restore Certification Quiz

1. What does wal_level = replica enable in PostgreSQL?

Archiving of WAL files for PITR

Replication to standby servers

Both A and B

Compression of backup files

2. Streaming replication can be used as a backup method for continuous data protection.

True

False

3. What is the primary difference between a logical backup and a physical backup?

Logical captures SQL objects; physical captures raw files

Logical is faster but less portable

Physical backups cannot be compressed

Logical backups require less disk space

4. Recovery_target_xid allows recovery to a specific transaction ID during PITR.

True

False

5. Which backup format created by pg_dump can be restored selectively with pg_restore?

Custom format (-F c)

Plain text format (-F p)

TAR format (-F t)

Both A and C

6. The restore_command is executed during PITR to retrieve archived WAL files.

True

False

7. What is the advantage of using pg_basebackup over pg_dump for large databases?

Faster backup and supports incremental restoration

Creates smaller backup files

More portable across versions

Easier to restore individual tables

8. Pg_dumpall backs up all databases and global objects like roles and tablespaces.

True

False

9. Which file contains PostgreSQL configuration settings for recovery?

Recovery.conf

Postgresql.conf

Pg_hba.conf

Backup.conf

10. The recovery_target_timeline parameter specifies which timeline to recover to during PITR.

True

False

11. Which PostgreSQL utility creates a logical backup of a database in SQL format?

Pg_dump

Pg_basebackup

Pg_restore

Pg_backup

12. PITR allows recovery to any point in time as long as WAL files are available.

True

False

13. Which command restores a backup created by pg_dump in custom format?

Pg_restore

Psql

Pg_basebackup

Pg_load

14. What does the -F c option do when used with pg_dump?

Creates a custom binary format backup

Compresses the output automatically

Copies database to another server

Clears the backup directory

15. Pg_dump produces a backup format that is portable across different PostgreSQL versions.

True

False

16. Which parameter controls where PostgreSQL archives WAL files?

Wal_level

Archive_command

Backup_path

Restore_command

17. What is the primary purpose of the pg_basebackup utility?

To create a physical backup of the entire cluster

To restore individual tables

To compress backup files

To encrypt backup data

18. Point-in-time recovery (PITR) requires archiving which type of data?

Transaction logs (WAL files)

Logical backups only

Database schema files

Index definitions

19. Which backup method captures the physical file structure of a running PostgreSQL cluster?

Pg_dump

Pg_basebackup

Pg_dumpall

COPY command

20. What does WAL stand for in PostgreSQL?

Write Ahead Logging

Web Archive Library

Workload Analysis Layer

Warehouse Allocation List

PostgreSQL Associate Backup and Restore Quiz

1. What does wal_level = replica enable in PostgreSQL?

2.

What first name or nickname would you like us to use?

2. Streaming replication can be used as a backup method for continuous data protection.

3. What is the primary difference between a logical backup and a physical backup?

4. Recovery_target_xid allows recovery to a specific transaction ID during PITR.

5. Which backup format created by pg_dump can be restored selectively with pg_restore?

6. The restore_command is executed during PITR to retrieve archived WAL files.

7. What is the advantage of using pg_basebackup over pg_dump for large databases?

8. Pg_dumpall backs up all databases and global objects like roles and tablespaces.

9. Which file contains PostgreSQL configuration settings for recovery?

10. The recovery_target_timeline parameter specifies which timeline to recover to during PITR.

11. Which PostgreSQL utility creates a logical backup of a database in SQL format?

12. PITR allows recovery to any point in time as long as WAL files are available.

13. Which command restores a backup created by pg_dump in custom format?

14. What does the -F c option do when used with pg_dump?

15. Pg_dump produces a backup format that is portable across different PostgreSQL versions.

16. Which parameter controls where PostgreSQL archives WAL files?

17. What is the primary purpose of the pg_basebackup utility?

18. Point-in-time recovery (PITR) requires archiving which type of data?

19. Which backup method captures the physical file structure of a running PostgreSQL cluster?

20. What does WAL stand for in PostgreSQL?