A company's online shopping website became unusable shortly after midnight on January 30, 2023. When a security analyst reviewed the database server, the analyst noticed the following code used for backing up data: Which of the following should the analyst do next?
Choose an answer
Tap an option to check your answer.
Correct answer: Check for recently terminated DBAs..
Why this is the answer
The code DELETE FROM products; DELETE FROM orders; is a malicious SQL command designed to wipe critical data from a database. This type of action is highly indicative of an insider threat, specifically a disgruntled employee with database access. Checking for recently terminated DBAs (Database Administrators) is the most logical next step because they would have the necessary privileges and potential motive to execute such a destructive command. Reviewing WAF logs for command injection is less likely to be the primary cause, as this code appears to be directly executed on the database server, not necessarily through a web application vulnerability. Scanning for malware is a good general practice but doesn't directly address the specific nature of the data deletion. Searching for ransomware notes is incorrect because the data was deleted, not encrypted for ransom.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed