An Administrator manages a Vantage system that is continually updated. The system is critical to the business and must be available as much as…

An online backup strategy is specifically designed for high-availability systems where continuous operation is critical. This method allows backup operations to run concurrently with user transactions, including DML changes (inserts, updates, deletes) to the tables being backed up. The system achieves this by placing read locks on the data blocks, which prevents structural changes (DDL) but permits ongoing data modifications. This ensures the database remains accessible and operational for business users during the backup process, directly meeting the administrator's requirements for a continually updated, business-critical system.

A. Offline: An offline backup requires the database or tables to be taken offline or placed under an exclusive lock, preventing any user access or modifications during the backup.

B. Skip statistics: This is a backup job option that excludes collected statistics from the archive. It is not a backup strategy that defines the availability of the system during the process.

D. Dictionary Only: This specifies the scope of the backup, limiting it to the Data Dictionary (DBC) tables. It does not back up user data tables or define the online/offline nature of the operation.

1. Teradata Vantage™ Data Stream Architecture User Guide, Release 17.20, B035-3150-0222K. In Chapter 4: Backup Jobs, the section "Online Archive" states, "Online archive allows you to back up databases and tables while they are being accessed and updated by other users. Online archive is the default." This directly supports the use of an online strategy for systems with concurrent updates.

2. Teradata® Archive/Recovery Utility Reference, Release 16.20, B035-2412-057K. In Chapter 2: ARCHIVE, the description of the LOGGING ONLINE ARCHIVE option explains, "When you specify ONLINE, Archive places a read lock on objects as they are being archived. This allows other users to have read and write access to the objects during the archive." This confirms that online backups permit changes.

3. Teradata Vantage™ Database Administration, Release 17.20, B035-1093-0322K. In Chapter 13: Archiving Data, the section "Archive and Recovery Concepts" discusses the importance of backup strategies for business continuity. It implicitly supports online backups by detailing how Teradata utilities are designed to work on active systems to minimize downtime, a core principle of online operations.