exam questions

Exam SY0-501 All Questions

View all questions & answers for the SY0-501 exam

Exam SY0-501 topic 1 question 652 discussion

Actual exam question from CompTIA's SY0-501
Question #: 652
Topic #: 1
[All SY0-501 Questions]

A security analyst identified an SQL injection attack.
Which of the following is the FIRST step in remediating the vulnerability?

  • A. Implement stored procedures.
  • B. Implement proper error handling.
  • C. Implement input validations.
  • D. Implement a WAF.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
MagicianRecon
Highly Voted 4 years, 10 months ago
There would always be input validation FIRST, be it at the client side or server side or both. Input validation also contains error and exception handling.
upvoted 11 times
...
mcNik
Most Recent 4 years, 3 months ago
Excuse me , how security analyst implements input validation... :D its most appropriate to WAF and then set all different settings. Input validation along with Stored procedures can be done by the devs .
upvoted 4 times
Heymannicerouter
4 years ago
In CompTIA world, security analyst is also a dev apparently.
upvoted 1 times
...
...
clay09
4 years, 10 months ago
if this makes sense, the attack has been detected because the entry point was allowing special characters at the input side which is not been properly validated.
upvoted 3 times
...
Meredith
4 years, 11 months ago
From Darrel Gibson's book, both stored procedures and input validation prevent SQL injection attacks. Does anyone know why input validation is the better answer here?
upvoted 3 times
Not_My_Name
4 years, 6 months ago
Because you should validate the input prior to it being forwarded to the stored procedures. Always validate input before processing it; people are stupid and enter the weirdest s**t.
upvoted 9 times
Computerguy
3 years, 11 months ago
thanks for making this a memorable question
upvoted 2 times
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago