nerdexam
CompTIA

CAS-002 · Question #622

The Chief Executive Officer (CEO) has asked the IT administrator to protect the externally facing web server from SQL injection attacks and ensure the backend database server is monitored for…

The correct answer is A. WAF and DAM. A WAF blocks SQL injection at the application layer while a DAM monitors database activity in real time and can enforce policies to terminate suspicious sessions.

Technical Integration of Enterprise Components

Question

The Chief Executive Officer (CEO) has asked the IT administrator to protect the externally facing web server from SQL injection attacks and ensure the backend database server is monitored for unusual behavior while enforcing rules to terminate unusual behavior. Which of the following would BEST meet the CEO's requirements?

Options

  • AWAF and DAM
  • BUTM and NIDS
  • CDAM and SIEM
  • DUTM and HSM
  • EWAF and SIEM

How the community answered

(55 responses)
  • A
    80% (44)
  • B
    5% (3)
  • C
    2% (1)
  • D
    9% (5)
  • E
    4% (2)

Why each option

A WAF blocks SQL injection at the application layer while a DAM monitors database activity in real time and can enforce policies to terminate suspicious sessions.

AWAF and DAMCorrect

A Web Application Firewall inspects HTTP and HTTPS requests and applies rule sets specifically designed to detect and block SQL injection payloads before they reach the backend database, fulfilling the web server protection requirement. A Database Activity Monitoring solution provides continuous, real-time visibility into database queries and transactions, detects anomalous behavior such as unexpected bulk data access, and can enforce active response policies - including session termination - to stop threats in progress, directly satisfying the enforcement requirement.

BUTM and NIDS

A UTM can provide general network filtering but lacks the deep, application-layer SQL injection rule enforcement that a WAF provides, and a NIDS is a passive detection system that cannot actively terminate database sessions.

CDAM and SIEM

A DAM alone cannot protect the web server from SQL injection at the HTTP layer, and a SIEM only aggregates and correlates log data for alerting without providing real-time database session enforcement or web-layer blocking.

DUTM and HSM

A UTM does not offer the precision SQL injection protection of a dedicated WAF, and an HSM is a cryptographic key management device with no capability to monitor or terminate database behavior.

EWAF and SIEM

A SIEM collects and correlates security event data for analyst review but cannot actively block SQL injection at the application layer or enforce automated termination rules against unusual database activity.

Concept tested: WAF for SQL injection protection and DAM for database enforcement

Source: https://owasp.org/www-community/controls/Web_Application_Firewall

Topics

#WAF#SQL injection#DAM#database activity monitoring

Community Discussion

No community discussion yet for this question.

Full CAS-002 Practice