A database administrator needs to ensure database backups are occurring on a daily basis and at scheduled times. Which of the following actions should the administrator take?

Question

Options

• AQuery the database to observe entries.
• BCheck the database schema.
• CReview the backup media.
• DReview the server logs for entries.

• A
  6% (2)
• B
  3% (1)
• C
  15% (5)
• D
  76% (25)

Explanation

To confirm that automated backups are running on schedule, a DBA should review the server logs for entries (option D). Database backup systems - whether built-in (SQL Server Agent, pg_cron, etc.) or third-party - write timestamped log entries indicating when a backup job started, completed, and whether it succeeded or failed. These logs provide definitive evidence of backup execution history and timing. Option A (querying the database for entries) checks data content, not backup activity. Option B (checking the database schema) shows table structure, unrelated to backup scheduling. Option C (reviewing the backup media) confirms that backup files exist but does not confirm the schedule or frequency of future runs; it is also less efficient than reading logs.

No community discussion yet for this question.