Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Cisco 300-220 Exam - Topic 6 Question 12 Discussion

Refer to the exhibit.The cybersecurity team at a company detects an ongoing attack directed at the web server that hosts the company website. The team analyzes the logs of the web application firewall and discovers several HTTP requests encoded in Base64. The team decodes the payloads and retrieves the HTTP requests. What did the attackers use to exploit the server?
B) SQL injection
A) Unicode encoding
C) directory traversal
D) cross-site scripting (XSS)

Cisco 300-220 Exam - Topic 6 Question 12 Discussion

Actual exam question for Cisco's 300-220 exam
Question #: 12
Topic #: 6
[All 300-220 Questions]

Refer to the exhibit.

The cybersecurity team at a company detects an ongoing attack directed at the web server that hosts the company website. The team analyzes the logs of the web application firewall and discovers several HTTP requests encoded in Base64. The team decodes the payloads and retrieves the HTTP requests. What did the attackers use to exploit the server?

Show Suggested Answer Hide Answer
Suggested Answer: B

The correct answer is SQL injection. The decoded HTTP request shown in the exhibit contains multiple unmistakable indicators of a SQL injection attack, including the use of SQL keywords and functions such as SELECT, CASE, SUBSTRING, ASCII, BIN, and conditional SLEEP() statements. These elements are characteristic of time-based blind SQL injection, a technique attackers use to extract database information when direct query results are not visible.

From a professional cybersecurity perspective, the presence of expressions like:

SELECT (CASE WHEN ... THEN SLEEP(x))

SUBSTRING(password,1,1)

ASCII() and binary conversions

indicates that the attacker is probing the backend database character by character and using response timing to infer whether conditions are true or false. This is a well-known exploitation method used when error messages or query output are suppressed by the application.

The use of Base64 encoding does not represent the attack itself but rather an obfuscation technique to evade basic web application firewall (WAF) signatures and logging visibility. Encoding payloads allows attackers to bypass simple pattern-matching defenses, but once decoded, the underlying SQL injection becomes evident.

Option A (Unicode encoding) is incorrect because Unicode is commonly used for evasion, not exploitation. Option C (directory traversal) typically involves sequences like ../ to access filesystem paths, which are not present. Option D (XSS) targets client-side script execution and would include JavaScript payloads rather than database-focused logic.

According to the MITRE ATT&CK framework, this activity maps to Initial Access -- Exploit Public-Facing Application (T1190). SQL injection remains one of the most exploited vulnerabilities in public-facing applications due to poor input validation and insecure coding practices.

For threat hunters and defenders, this scenario reinforces the importance of deep payload inspection, decoding obfuscated requests, monitoring for anomalous database query behavior, and enforcing secure development practices such as parameterized queries and input sanitization. SQL injection continues to be a high-impact, real-world attack vector despite being well understood, making it a critical focus area in web application threat hunting.


Contribute your Thoughts:

0/2000 characters
Zack
3 days ago
Exactly! Encoded payloads often indicate SQL attacks.
upvoted 0 times
...
Cherri
8 days ago
I doubt C. The Base64 encoding points more towards SQL injection.
upvoted 0 times
...
Joni
13 days ago
But what about C) directory traversal? Could be a possibility too.
upvoted 0 times
...
Terina
19 days ago
I agree, SQL injection makes sense here. The logs show unusual queries.
upvoted 0 times
...
Zack
24 days ago
I think it's definitely B) SQL injection. It fits the scenario.
upvoted 0 times
...
Kanisha
29 days ago
I thought Unicode encoding was a thing too, but not here!
upvoted 0 times
...
Edison
1 month ago
Could also be directory traversal, but SQL seems more likely.
upvoted 0 times
...
Magda
1 month ago
Wait, Base64? That’s a bit odd for XSS, right?
upvoted 0 times
...
Galen
1 month ago
Totally agree, SQL injection fits the scenario.
upvoted 0 times
...
Pura
2 months ago
Looks like they used SQL injection.
upvoted 0 times
...
Fernanda
2 months ago
Cross-site scripting (XSS) seems less likely since it usually doesn't involve Base64 encoding. I feel like SQL injection is the most relevant here.
upvoted 0 times
...
Leanna
2 months ago
I practiced a similar question where encoding was involved, and I think directory traversal could be a possibility here, but I need to double-check my notes.
upvoted 0 times
...
Hubert
2 months ago
I think this might relate to SQL injection since those often involve manipulating HTTP requests, but I'm not entirely sure.
upvoted 0 times
...
Herman
2 months ago
I remember studying about how attackers often use encoding techniques like Base64 to obfuscate their payloads. It makes it tricky to spot the real attack.
upvoted 0 times
...

Save Cancel