Senior PostgreSQL

Test your Senior-level Relational Databases Postgresql skills in Database Data Management. This timed assessment evaluates your expertise in Information Technology.

Duration: 5 minutes

•40 questions

Time Remaining: 05:00

Progress: 0%

40 questions remaining

Question 1 of 40Assessment

When configuring synchronous replication, what happens if the 'synchronous_standby_names' is set to 'FIRST 2 (s1, s2, s3)'?

A. Transactions commit only after s1 and s2 acknowledge receipt, while s3 remains asynchronous.

B. The primary waits for any two out of the three named standbys to acknowledge the transaction.

C. The first two standby nodes that connect to the primary become the designated synchronous pair.

D. Commit is successful if s1 confirms; s2 and s3 are used only as backups for the primary's WAL stream.

Keyboard Shortcuts

↑↓Navigate options

EnterSelect answer

←→Prev/Next question

SSkip question

1-4Select A-D

EscClear answer

SpaceNext question

BackspacePrevious question