ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 242 - PT0-002 discussion

Report
Export

A penetration tester found several critical SQL injection vulnerabilities during an assessment of a client's system. The tester would like to suggest mitigation to the client as soon as possible.

Which of the following remediation techniques would be the BEST to recommend? (Choose two.)

A.
Closing open services
Answers
A.
Closing open services
B.
Encryption users' passwords
Answers
B.
Encryption users' passwords
C.
Randomizing users' credentials
Answers
C.
Randomizing users' credentials
D.
Users' input validation
Answers
D.
Users' input validation
E.
Parameterized queries
Answers
E.
Parameterized queries
F.
Output encoding
Answers
F.
Output encoding
Suggested answer: D, E

Explanation:

SQL injection is a type of attack that exploits a vulnerability in a web application that allows an attacker to execute malicious SQL statements on a database server. SQL injection can result in data theft, data corruption, authentication bypass, or command execution. To mitigate SQL injection vulnerabilities, the following remediation techniques are recommended:

Users' input validation: This involves checking and sanitizing the user input before passing it to the database server. Input validation can prevent malicious or unexpected input from reaching the database server and causing harm. Input validation can be done by using whitelists, blacklists, regular expressions, or escaping mechanisms.

Parameterized queries: This involves using placeholders or parameters for user input instead of concatenating it with the SQL statement. Parameterized queries can separate the user input from the SQL logic and prevent it from being interpreted as part of the SQL statement. Parameterized queries can be implemented by using prepared statements, stored procedures, or frameworks that support them. The other options are not relevant or effective remediation techniques for SQL injection vulnerabilities.

asked 02/10/2024
Veronica Puddu
54 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first