You need to take a full online base backup of your cluster using pg_basebackup. Which option specifies the output directory?

• A.-d directory
• B.--output directory
• C.-o directory
• D.-D directory

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of shared_buffers configuration parameter in PostgreSQL?

• A.To set connection pool size
• B.To control WAL buffer size
• C.To determine memory for caching data from disk
• D.To set the amount of memory for sorting

Comment: *

Name: *

Email: *

Verification: *

While connected to a PostgreSQL database using psql, you want to toggle the timing information of some queries. Which of the following options can be used to achieve this?

• A.\time off
• B.\timing
• C.\time on
• D.\t

Comment: *

Name: *

Email: *

Verification: *

Which pg_dump option allows you to dump only the data without schema definitions?

• A.--no-schema
• B.-D
• C.--data-only
• D.-d

Comment: *

Name: *

Email: *

Verification: *

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

• A.wal_level = archive
• B.wal_level = replica
• C.wal_level = minimal
• D.wal_level = logical

Comment: *

Name: *

Email: *

Verification: *