nerdexam
EC-Council

312-39 · Question #99

Pearl is a Level 1 SOC analyst at a global financial institution using SQL Server to store sensitive customer information. She investigates an alert showing multiple failed web app logins from the sam

Sign in or unlock 312-39 to reveal the answer and full explanation for question #99. The question stem and answer options stay visible for context.

Security Incident Detection

Question

Pearl is a Level 1 SOC analyst at a global financial institution using SQL Server to store sensitive customer information. She investigates an alert showing multiple failed web app logins from the same IP, followed by a successful login as a server administrator. She then reviews SQL Server logs and finds the attacker used compromised credentials to access the SQL Server database. Which log will help identify whether the intruder performed unauthorized modifications in the database?

Options

  • ATransaction log
  • BSecurity log
  • CMaintenance log
  • DAudit log

Unlock 312-39 to see the answer

You've previewed enough free 312-39 questions. Unlock 312-39 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#transaction log#SQL Server#database forensics#unauthorized modification
Full 312-39 Practice