ExpertHard1 markMultiple Choice
CPA · Question 74 · Area II: Security
Which of the following is a 'Preventive' control for 'SQL Injection'?
Which of the following is a 'Preventive' control for 'SQL Injection'?
Answer options:
A.
Web Application Firewall (WAF)
B.
Using Parameterized Queries / Prepared Statements
C.
Database Encryption
D.
Regular Backups
How to approach this question
SQL Injection fix = Parameterized Queries.
Full Answer
B.Using Parameterized Queries / Prepared Statements✓ Correct
Parameterized queries ensure that the database treats user input as data, not executable code, effectively neutralizing SQL injection attacks.
Common mistakes
Relying on WAFs (which can be bypassed) instead of fixing the code.
Practice the full CPA ISC Practice Exam 4
82 questions · hints · full answers · grading
More questions from this exam
Q01A CPA is advising a client who is migrating their legacy on-premise ERP system to a cloud environ...HardQ02An auditor is reviewing the Service Level Agreement (SLA) for a client using a public cloud provi...HardQ03A company uses an Infrastructure as a Service (IaaS) model. During an IT audit, the auditor disco...HardQ04An organization is implementing the COSO Enterprise Risk Management (ERM) framework to govern its...HardQ05During a walkthrough of an order-to-cash process, the auditor observes that the sales manager can...Hard