EnterpriseDB PostgreSQL-Essentials Exam Questions Instant Access

Question 1

Which parameter sets the number of autovacuum worker processes?

Aautovacuum_workers

Bautovacuum_max_workers

Cmax_autovacuum_workers

Dvacuum_workers

Answer : B

Question 2

Which pg_dump option creates a backup that can be restored using pg_restore?

A-Fp (plain text format)

B-Fc (custom format)

C-Ft (tar format)

DBoth B and C

Answer : D

Question 3

Which pg_restore option allows you to drop database objects before recreating them?

A-d

B-c or --clean

C-r

D--drop-all

Answer : B

Question 4

Which PostgreSQL configuration parameter controls the amount of memory used for sorting operations before writing to temporary disk files?

Ashared_buffers

Bwork_mem

Cmaintenance_work_mem

Dtemp_buffers

Answer : B

Question 5

In PostgreSQL 13, which parameter must be set to enable WAL archiving for Point-in-Time Recovery?

Awal_level must be set to replica or higher

Bwal_archiving must be set to on

Carchive_level must be set to full

Dbackup_mode must be set to archive

Answer : A

Question 6

You need to restore only the schema from a custom format backup file. Which pg_restore option should you use?

A--data-only

B--schema-only

C-s

DBoth B and C

Answer : D

Question 7

You want to update statistics for the emp and dept tables to help the query planner. Which command should you use?

AVACUUM emp, dept;

BANALYZE emp; ANALYZE dept;

CUPDATE STATISTICS emp, dept;

DREINDEX emp, dept;

Answer : B

EnterpriseDB PostgreSQL Essentials Certification v13 PostgreSQL-Essentials Exam Questions