You want to set temporary memory to 8MB. Which parameter should you configure?

• A.temp_buffers = 8MB
• B.temporary_memory = 8MB
• C.work_mem = 8MB
• D.temp_memory = 8MB

Comment: *

Name: *

Email: *

Verification: *

Which parameter sets the number of autovacuum worker processes?

• A.max_autovacuum_workers
• B.vacuum_workers
• C.autovacuum_max_workers
• D.autovacuum_workers

Comment: *

Name: *

Email: *

Verification: *

Which system view provides real-time information about currently active sessions and running queries?

• A.pg_stat_activity
• B.pg_active_sessions
• C.pg_current_queries
• D.pg_sessions

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements is true about PostgreSQL 13?

• A.ALTER CLUSTER writes the setting to a file called postgresql.auto.conf
• B.ALTER SYSTEM writes the setting to a file called postgresql.conf
• C.ALTER CLUSTER writes the setting to a file called postgresql.conf
• D.ALTER SYSTEM writes the setting to a file called postgresql.auto.conf

Comment: *

Name: *

Email: *

Verification: *

You are working as a Postgres DBA. You want to configure logging for slow running queries on your database cluster. Which setting needs to be modified to log all the queries which take more than 5 seconds?

• A.log_duration
• B.log_statement
• C.log_destination
• D.log_min_duration_statement

Comment: *

Name: *

Email: *

Verification: *