nerdexam
CompTIA

CAS-002 · Question #652

An administrator is reviewing logs and sees the following entry: Message: Access denied with code 403 (phase 2). Pattern match "\bunion\b.{1,100}?\bselect\b" at ARGS:$id. [data "union all select"]…

The correct answer is C. SQL injection. The WAF log entry reveals a blocked SQL UNION SELECT injection attempt, identifiable by the regex pattern, the matched payload, and the OWASP/WASC tags referencing SQL injection.

Enterprise Security

Question

An administrator is reviewing logs and sees the following entry:

Message: Access denied with code 403 (phase 2). Pattern match "\bunion\b.{1,100}?\bselect\b" at ARGS:$id. [data "union all select"] [severity "CRITICAL"] [tag "WEB_ATTACK"] [tag "WASCTC/WASC-19"] [tag "OWASP_TOP_10/A1"] [tag "OWASP_AppSensor/CIE1"] Action: Intercepted (phase 2) Apache-Handler: php5-script Which of the following attacks was being attempted?

Options

  • ASession hijacking
  • BCross-site script
  • CSQL injection
  • DBuffer overflow

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    83% (24)
  • D
    10% (3)

Why each option

The WAF log entry reveals a blocked SQL UNION SELECT injection attempt, identifiable by the regex pattern, the matched payload, and the OWASP/WASC tags referencing SQL injection.

ASession hijacking

Session hijacking involves stealing or forging authentication session tokens, not crafting UNION SELECT SQL syntax against a query parameter.

BCross-site script

Cross-site scripting injects client-side script payloads into web page output, whereas this log shows SQL keyword patterns targeting a backend database query.

CSQL injectionCorrect

The log pattern `\bunion\b.{1,100}?\bselect\b` and the matched data `union all select` are classic signatures of a SQL injection attack using a UNION-based technique to append a secondary SELECT query. The tags WASCTC/WASC-19 and OWASP_TOP_10/A1 explicitly categorize the event as SQL injection, and the ModSecurity WAF intercepted it at phase 2 before the query could reach the database.

DBuffer overflow

Buffer overflow attacks target memory boundaries in application code, not SQL query parsers, and produce entirely different signatures than UNION SELECT strings.

Concept tested: SQL injection attack identification from WAF log entries

Source: https://owasp.org/www-community/attacks/SQL_Injection

Topics

#SQL injection#WAF log analysis#OWASP Top 10#attack identification

Community Discussion

No community discussion yet for this question.

Full CAS-002 Practice