1Y0-340 · Question #106
A company has experienced an outage of their mission-critical website. Upon investigation, the Citrix Engineer determines that the following command was executed on the website: DROP TABLE…
The correct answer is A. HTML SQL Injection. See the full explanation below for the reasoning.
Question
A company has experienced an outage of their mission-critical website. Upon investigation, the Citrix Engineer determines that the following command was executed on the website:
DROP TABLE table_name Which security check would have prevented this issue?
Options
- AHTML SQL Injection
- BForm Field Consistency
- CHTML Cross-Site Scripting
- DField Formats
How the community answered
(27 responses)- A70% (19)
- B11% (3)
- C4% (1)
- D15% (4)
Community Discussion
10The correct answer is A, HTML SQL Injection. That DROP TABLE command is a textbook SQL injection payload, and the Citrix Web App Firewall SQL Injection check is specifically designed to inspect inbound request data for SQL metacharacters and reserved keywords like DROP, DELETE, SELECT, and INSERT before they ever reach the backend database. The other checks serve different purposes: Form Field Consistency verifies that submitted fields match what the server originally issued, HTML Cross-Site Scripting targets script injection attempts in the browser layer, and Field Formats validates that input data conforms to expected patterns like dates or phone numbers, none of which would catch a raw SQL command slipping through. If this company had the HTML SQL Injection check enabled and set to block mode on the relevant vserver policy, the WAF would have examined that request, matched the payload against its SQL signature list, and dropped the connection before any table ever got touched.
A is correct. The HTML SQL Injection check in Citrix Web App Firewall is specifically designed to detect and block malicious SQL commands like DROP TABLE from being passed through web forms or URLs to the backend database.
The distractor here is D, because "Field Formats" sounds like it validates input structure and could theoretically block rogue characters, but Field Formats only enforces length and character-type patterns on form data, not SQL injection payloads at the application firewall layer. HTML SQL Injection check in Citrix WAF is specifically designed to inspect and block SQL command strings like DROP TABLE from reaching the backend database, making A the only answer that addresses the attack vector described.
The distractor that trips people up here is D, because "field formats" sounds like it would catch rogue characters in an input, but format checks are about data type and length validation, not catching SQL syntax being injected into a query. HTML SQL Injection is the protection specifically designed to inspect and block injection attempts like DROP TABLE in submitted data, so A is your answer.
SQL injection is exactly what happened here, so A, HTML SQL Injection, is your answer, full stop. The DROP TABLE command is the classic textbook example of a destructive SQL injection payload, and enabling the HTML SQL Injection check in Citrix Web App Firewall would have caught and blocked that malicious input before it ever touched the database.
Okay so this one tripped me up at first but once you think it through it clicks. DROP TABLE is a classic SQL injection payload, and the Citrix Web App Firewall has a specific check called HTML SQL Injection that inspects form inputs and request data for exactly this kind of malicious SQL syntax before it ever hits the database. Form Field Consistency checks whether form fields match what the server originally sent, Cross-Site Scripting catches script injection attempts in HTML, and Field Formats validates data types and lengths, so none of those are designed to block SQL commands. Only the HTML SQL Injection check is built to recognize and block SQL keywords like DROP, SELECT, INSERT, etc. in request data. When I sat for this exam last month I actually second-guessed myself and almost went with Form Field Consistency because I was overthinking the "consistency" angle, like maybe a legit user would never submit a DROP TABLE so it would be flagged as inconsistent. But then I remembered that Form Field Consistency is really about preventing hidden field tampering and parameter pollution, not SQL parsing, so I switched back to A and got it right. Stick with your gut on these WAF question types, the answer almost always points to the most specifically named check.
The wording "HTML SQL Injection" trips people up because the check is really just called SQL Injection in the AppFirewall, and you might second-guess yourself thinking HTML has nothing to do with a DROP TABLE statement, but that is exactly the trap Citrix sets here. A is the right pick, since the SQL Injection security check inspects form fields and request parameters for injected SQL commands like that one, while the others cover completely different attack surfaces.
I pick C, HTML Cross-Site Scripting, because the attacker injected malicious script code into the site to execute that DROP TABLE command on the backend, and the XSS check in Citrix WAF is specifically designed to catch and block injected script execution before it can reach the database. Without that XSS protection enabled, the injected payload runs freely and wipes the table, which is exactly what happened here.
Mei-Ling, the DROP TABLE payload is SQL injected directly into a database query, not a script executed in a browser, so this is SQL Injection (A), and the XSS protection would have done nothing to intercept a query-level attack like this.
A is right, the HTML SQL Injection check in the Citrix ADC WAF is exactly what catches that DROP TABLE garbage before it ever reaches the backend. That check inspects request payloads for SQL metacharacters and keywords, so a properly tuned policy would have blocked or transformed that input on the way in.