Exam HPE0-J82 Topic 1 Question 22 Discussion

Actual exam question for HP's HPE0-J82 exam
Question #: 22
Topic #: 1

An HPE Pre-Sales Consultant is discussing disaster recovery strategies with a customer. The customer plans to rely entirely on native storage array snapshots (taken every 5 minutes) to protect a highly transactional Microsoft SQL Server database running on a bare-metal Windows server connected via Fibre Channel.
If the customer executes these storage array snapshots natively via the array's GUI without any host-level integration, what is the exact consistency state of the resulting snapshot, and what operational risk does this pose during a recovery?

A. The snapshot is "Application-Consistent"; the array's ASICs automatically inspect the SQL payloads in flight to ensure zero transactions are dropped, guaranteeing instant recovery B. The snapshot is "Crash-Consistent"; the array captures the exact state of the disk blocks at that millisecond, completely ignoring data held in the Windows OS RAM or SQL buffers, risking database corruption and requiring a lengthy database log replay upon recovery C. The snapshot is "Log-Consistent"; the array forces the SQL server to truncate its transaction logs to the snapshot delta file, preventing any data loss but corrupting the active database D. The snapshot is "File-System-Consistent"; the array natively flushes the NTFS metadata tables before snapping the blocks, ensuring the OS boots perfectly but leaving the SQL application state unknown

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business