HP0-J73 · Question #117
A company has a large database application that runs on Microsoft SQL Server 2012 on an HP 3PAR StoreServe array. The company's current backup strategy is to use tapes for archived storage. The compan
The correct answer is B. Snapshots. Array-based snapshots provide near-instant, consistent point-in-time copies of a database volume, enabling the fastest possible recovery of transactional data without a full tape restore.
Question
A company has a large database application that runs on Microsoft SQL Server 2012 on an HP 3PAR StoreServe array. The company's current backup strategy is to use tapes for archived storage. The company needs to minimize the recovery time required to restore transactional data. Which technology should the company use?
Exhibit
Options
- ARAID mirroring
- BSnapshots
- CRemote replication
- DSQL mirroring
How the community answered
(60 responses)- A5% (3)
- B85% (51)
- C8% (5)
- D2% (1)
Why each option
Array-based snapshots provide near-instant, consistent point-in-time copies of a database volume, enabling the fastest possible recovery of transactional data without a full tape restore.
RAID mirroring protects against physical disk failure but provides no point-in-time recovery capability - a logical corruption or accidental deletion is mirrored to both sides immediately.
HP 3PAR StoreServ supports hardware-level snapshots that integrate with Microsoft VSS to capture a crash-consistent or application-consistent copy of the SQL Server database in seconds. Restoring from a snapshot is essentially remounting the volume copy, which can reduce recovery time from hours to minutes compared to streaming data back from tape. This directly addresses the requirement to minimize recovery time for transactional data.
Remote replication continuously mirrors data to a secondary site for disaster recovery purposes but does not retain historical transactional states needed for rapid in-place data restoration.
SQL Server mirroring provides automatic failover to a standby server for high availability but is not a backup or restore mechanism for recovering specific transactional data.
Concept tested: Array snapshots for minimizing database recovery time
Source: https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/back-up-and-restore-of-sql-server-databases
Topics
Community Discussion
No community discussion yet for this question.