Which backup strategy should be used?

An Administrator manages a Vantage system that is continually updated. The system is critical to the business and must be available as much as possible. The Administrator decides to use a backup strategy that will allow changes to tables while a backup is in progress.

Which backup strategy should be used?
A . Offline
B . Skip statistics
C . Online
D . Dictionary Only

View Answer

Answer: C

Explanation:

An Online backup strategy allows the database to remain accessible and operational while the backup is taking place. This means that users can continue to modify data, and the system can remain available without requiring downtime. It is a common approach for mission-critical systems that need to maximize uptime.

Offline would require the system or certain tables to be unavailable during the backup process, which is not suitable for a system that needs to remain available.

Skip statistics refers to skipping the backup of statistics on database objects and does not relate to whether the system can be updated during the backup.

Dictionary Only involves backing up only the system catalog or dictionary data, not the actual table data, and would not fulfill the requirement of a comprehensive backup while allowing updates.