ISC2 Certified Cloud Security Professional (CCSP) Practice Question
While reviewing code for a new cloud-native microservice, you find functions that read user input from an API Gateway, concatenate that input into SQL statements, and execute them against an Azure SQL Database. To satisfy OWASP ASVS Level 2 requirements for injection defenses, which secure coding practice should the team implement first?
Suppress detailed database error messages returned to the client.
Replace string-built SQL with parameterized queries (prepared statements) that bind user input as data.
Encrypt database credentials with a hardware security module and load them at runtime.
Add a strict Content Security Policy (CSP) header to all HTTP responses.
OWASP ASVS Level 2 explicitly requires that all database access use parameterized queries or stored procedures so user-supplied data is passed to the database engine as bind variables, eliminating the possibility that input will be interpreted as part of the command. Encrypting secrets, suppressing verbose error messages, and adding CSP headers are valuable security measures, but none of them directly addresses the root cause of SQL injection, which is untrusted input being merged with executable code.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What are parameterized queries and why are they effective against SQL injection?
Open an interactive chat with Bash
What is OWASP ASVS Level 2 and what does it require for injection defenses?
Open an interactive chat with Bash
What is an API Gateway and how does it relate to secure code practices in microservices?
Open an interactive chat with Bash
ISC2 Certified Cloud Security Professional (CCSP)
Cloud Application Security
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .