350-701 · Question #693
A website administrator wants to prevent SQL injection attacks against the company's customer database, which is referenced by the web server. Which two methods help prevent SQL injection attacks?…
The correct answer is B. performing input validation E. using web application firewalls. To prevent SQL injection attacks, performing robust input validation on the application side and deploying a Web Application Firewall (WAF) are two effective methods.
Question
A website administrator wants to prevent SQL injection attacks against the company's customer database, which is referenced by the web server. Which two methods help prevent SQL injection attacks? (Choose two.)
Options
- Ausing load balancers with NAT
- Bperforming input validation
- Cenforcing TLS 1.3 only
- Dusing SSL certificates
- Eusing web application firewalls
How the community answered
(30 responses)- A13% (4)
- B73% (22)
- C3% (1)
- D10% (3)
Why each option
To prevent SQL injection attacks, performing robust input validation on the application side and deploying a Web Application Firewall (WAF) are two effective methods.
Using load balancers with NAT helps distribute traffic and hide internal network topology, which can be part of a robust architecture, but it does not specifically prevent SQL injection attacks.
Input validation involves strictly checking, filtering, and sanitizing all user-supplied data before it is processed by the application or used in database queries, directly preventing malicious SQL statements from being executed.
Enforcing TLS 1.3 only ensures secure, encrypted communication between the client and server, protecting data in transit, but it does not prevent malicious SQL queries from being submitted through legitimate application input fields.
Using SSL certificates enables encrypted communication and verifies server identity, similar to TLS, but does not provide protection against SQL injection attacks targeting the application's logic or database queries.
A Web Application Firewall (WAF) inspects HTTP/S traffic, identifies and blocks common web exploits like SQL injection by detecting malicious patterns in requests before they reach the web server and database.
Concept tested: SQL injection prevention techniques
Source: https://owasp.org/www-community/attacks/SQL_Injection
Topics
Community Discussion
No community discussion yet for this question.