Courseiva
Database SecuritymediumMultiple ChoiceObjective-mapped

DBS-C01 Database Security Practice Question

An application uses an Amazon RDS for MySQL database. The security team requires that all traffic to the database be encrypted in transit. Which configuration ensures this?

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

Create a custom DB parameter group with the require_secure_transport parameter set to ON.

Setting require_secure_transport to ON in a custom DB parameter group enforces SSL/TLS for all connections to the RDS MySQL database, ensuring encryption in transit. Option A is wrong because the default parameter group does not enforce SSL. Option C is wrong because security groups control network access at the port level, not encryption. Option D is wrong because network ACLs are stateless and do not enforce encryption.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Use the default RDS parameter group.

    Why it's wrong here

    The default RDS parameter group does not enforce SSL/TLS.

  • Create a custom DB parameter group with the require_secure_transport parameter set to ON.

    Why this is correct

    Setting require_secure_transport to ON enforces encrypted connections.

  • Configure the security group to allow only port 3306 from the application.

    Why it's wrong here

    Security groups restrict network access but do not enforce encryption.

  • Use a network ACL to restrict inbound traffic to port 3306.

    Why it's wrong here

    Network ACLs are stateless and do not enforce encryption.

About these practice questions

One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

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.