CompTIA DataSys+ (DS0-001)Data and Database SecurityMedium

A large e-commerce platform experienced a data breach where an attacker gained unauthorized access to their customer database through a misconfigured API endpoint. The database administrator needs to implement a solution that specifically monitors and analyzes database traffic, detects suspicious activities, and can alert security personnel in real-time. Which security tool would be most effective for this purpose?

  1. AIntrusion Prevention System (IPS)
  2. BSecurity Information and Event Management (SIEM)
  3. CDatabase Activity Monitoring (DAM)
  4. DWeb Application Firewall (WAF)
Show answer & explanation

Correct answer: C. Database Activity Monitoring (DAM)

Database Activity Monitoring (DAM) solutions are specifically designed to monitor and audit all activities occurring within a database, including SQL queries, administrative actions, and data access. They detect suspicious patterns and generate real-time alerts, making them ideal for identifying unauthorized database access and data exfiltration.

Why the other options are wrong

  • A. An IPS primarily monitors network traffic for known attack signatures and can block them, but it's less granular for database-specific activities.
  • B. SIEM aggregates logs and events from various sources for analysis, but a DAM provides the specific, granular database events for SIEM to consume.
  • D. A WAF protects web applications from common web-based attacks (like SQL injection) at the application layer, but not necessarily internal database activities post-breach.

Database Activity Monitoring (DAM)

Database Activity Monitoring (DAM) is a security technology that monitors and analyzes database events in real-time, providing visibility into database activity, detecting anomalies, and generating alerts for suspicious behavior.

  • Monitors SQL traffic and administrative commands.
  • Detects anomalous behavior and policy violations.
  • Provides real-time alerts and audit trails.

Memory trick: DAM watches the database dance.

More Data and Database Security questions