DBS-C01 Database Security Practice Question
A company is using Amazon RDS for MySQL to host a web application. The security team has identified that the application is vulnerable to SQL injection attacks. The team wants to implement a defense-in-depth strategy to protect the database. Which THREE measures should be taken to mitigate SQL injection risks?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Grant the minimum required permissions to the database user used by the application.
Options A, C, and E are correct. Parameterized queries (C) prevent SQL injection by separating SQL logic from data. Least privilege (A) reduces the impact if injection occurs. AWS WAF (E) provides a web application firewall to filter malicious input before it reaches the database. Option B is incorrect because stored procedures alone do not prevent SQL injection unless they use parameterized queries. Option D is incorrect because encryption at rest protects data at rest but does not prevent SQL injection.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Grant the minimum required permissions to the database user used by the application.
Why this is correct
Least privilege limits damage if injection occurs.
- ✗
Move all SQL logic into stored procedures.
Why it's wrong here
Stored procedures can be vulnerable if they concatenate input.
- ✓
Use parameterized queries or prepared statements in the application code.
Why this is correct
Parameterized queries prevent injection by separating data from code.
- ✗
Enable encryption at rest for the RDS instance.
Why it's wrong here
Encryption protects data at rest, not injection attacks.
- ✓
Deploy AWS WAF in front of the web application to filter malicious requests.
Why this is correct
WAF can block common SQL injection patterns.
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.