nerdexam
PostgreSQL_CE

PGCES-02 · Question #26

Select two incorrect statements about the Point-In-Time Recovery (PITR) from below.

The correct answer is B. It is necessary to stop the database server to perform a backup for the first time. E. A backup can only beperformed on a per-database basis. See the full explanation below for the reasoning.

Question

Select two incorrect statements about the Point-In-Time Recovery (PITR) from below.

Options

  • AThis is a backup method integrating a physical backup and a transaction log (WAL).
  • BIt is necessary to stop the database server to perform a backup for the first time.
  • CUpdated data iscontinuously saved.
  • DA restore can be performed to any arbitrary point in time since the starting point of PITR.
  • EA backup can only beperformed on a per-database basis.

How the community answered

(42 responses)
  • A
    10% (4)
  • B
    83% (35)
  • C
    2% (1)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice