HP0-J73 · Question #113
A company is planning an online backup strategy for a highly available database application. Which key component must be included in the backup strategy?
The correct answer is C. Transaction logs. Transaction logs record all database changes and are required for online backups to produce a consistent, recoverable state while the database remains active.
Question
A company is planning an online backup strategy for a highly available database application. Which key component must be included in the backup strategy?
Options
- ARollback logs
- BTemp logs
- CTransaction logs
- DEvent logs
How the community answered
(41 responses)- A2% (1)
- B7% (3)
- C88% (36)
- D2% (1)
Why each option
Transaction logs record all database changes and are required for online backups to produce a consistent, recoverable state while the database remains active.
Rollback logs (undo logs) are used internally by the database engine to reverse uncommitted transactions in flight and are not a recoverable artifact used in backup and restore operations.
Temp logs hold transient data for in-progress queries and temporary objects and are automatically discarded when sessions end, making them irrelevant to backup strategy.
Transaction logs capture every committed database operation and are essential for online backups because the database continues to process writes during the backup window, creating a moving target. They allow the database engine to roll the backup forward to a transactionally consistent point in time after the backup completes, which is the standard recovery mechanism for highly available databases that cannot be taken offline. Without transaction log backups included in the strategy, the resulting backup image would be crash-consistent at best and potentially unrestorable.
Event logs record application and system operational events at the OS or platform level and contain no database transaction data needed for backup consistency or recovery.
Concept tested: Transaction log backups for online database recovery
Source: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/transaction-log-backups-sql-server
Topics
Community Discussion
No community discussion yet for this question.