An organization is implementing database activity monitoring (DAM) to detect unauthorized data access and SQL injection attempts against their enterprise SQL Server databases. Where should the DAM sensor ideally be placed to capture all database queries accurately without relying solely on database logs?
A network tap or SPAN port captures the database protocol traffic on the wire, plus host-based driver interceptors, giving query visibility independent of SQL Server's own logs. This satisfies the requirement to capture all queries accurately without relying solely on database logs.
Why this answer
A DAM sensor captures database activity most accurately by sitting inline or out-of-band on the network path where database protocol traffic flows — typically via a network TAP or SPAN port mirroring the database VLAN — or by using host-based driver interceptors that hook the database client/server libraries. This captures the actual SQL statements on the wire (TDS for SQL Server, TNS for Oracle) independent of what the database chooses to log, which is critical because native audit logs can be tampered with or disabled by a compromised DBA.
Exam trap
The trap is that candidates pick 'database logs' or a generic network device because they sound plausible, but the question explicitly says 'without relying solely on database logs' — the exam tests whether you know DAM sensors must see the database wire protocol or hook the DB driver, not just any network vantage point.
How to eliminate wrong answers
Option B is wrong because a perimeter firewall inspecting ICMP echo requests only sees ping traffic, not the TDS/SQL statements that constitute database activity — ICMP has no relevance to SQL query monitoring. Option C is wrong because a DNS resolver cache only holds name-to-IP mappings; it never sees the SQL payloads inside database sessions. Option D is wrong because an SMTP email gateway relay filter processes email messages, not database wire protocols, so it cannot observe queries.