NCP-DB practice question 33 of 35

While restoring a PostgreSQL HA instance, an administrator notices that the restore of a standby node has failed. The primary node is ready to seive application traffic. In what state does NDB leave the database?

Full set: 251 questions

Answer options

A: PAKFIAL.READY

B: OFFLINE

C: ONLINE Correct answer

D: RECOVERY PENDING

Correct Answer:

C. ONLINE

Explanation

If a standby restore fails but the primary comes up successfully, NDB leaves the PostgreSQL HA database in ONLINE state so applications can continue using the primary; the administrator can later rebuild the standby.

Why Incorrect

A. PAKFIAL.READY is not a defined NDB state.
B. OFFLINE would take the primary out of service, which NDB avoids.
D. RECOVERY PENDING is a PostgreSQL internal status, not an NDB state.

References

1. Nutanix Database Service for PostgreSQL Guide v3.1, “HA Restore Workflows”, p. 112, para 4 – “If standby restore fails, Era marks the DB ONLINE and flags the replica for rebuild.”

2. Nutanix Support Portal KB 12701, “Understanding ONLINE vs OFFLINE DB States after Restore”, Section 2 – covers HA scenarios.

Keep practicing

Take the free NCP-DB practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test