Computer Hacking Forensic Investigator (CHFI) — Question 74

As a part of the investigation, Caroline, a forensic expert, was assigned the task to examine the transaction logs pertaining to a database named Transfers. She used SQL Server Management Studio to collect the active transaction log files of the database. Caroline wants to extract detailed information on the logs, including AllocUnitId, page id, slot id, etc. Which of the following commands does she need to execute in order to extract the desired information?

Answer options

• A. DBCC LOG(Transfers, 1)
• B. DBCC LOG(Transfers, 3)
• C. DBCC LOG(Transfers, 0)
• D. DBCC LOG(Transfers, 2)

Correct answer: D

Explanation

The correct command is DBCC LOG(Transfers, 2) because it provides detailed information about the transaction log, including AllocUnitId, page id, and slot id. The other options, while related, do not yield the same level of detail required for Caroline's investigation.