Question 255 of 1,663
DBS-C01 Database Security Practice Question
A security team is auditing an Amazon RDS for SQL Server DB instance. They notice that SSL connections are not enforced. Which configuration change will enforce SSL for all connections?
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
✓
Set the 'rds.force_ssl' parameter to 1 in the DB parameter group.
For Amazon RDS for SQL Server, you can enforce SSL connections by setting the 'rds.force_ssl' parameter to 1 in the DB parameter group. This forces all connections to use SSL. Option A is incorrect because security groups control network access but do not enforce encryption. Option B is incorrect because the option group manages features such as Transparent Data Encryption (TDE) and native backup/restore, not SSL enforcement. Option D is incorrect because changing the subnet to public would expose the instance to the internet and does not enforce SSL.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Modify the security group to only allow inbound traffic on port 443.
Why it's wrong here
SSL for SQL Server uses port 1433, not 443. Security groups do not enforce encryption.
- ✗
Add the SQL Server SSL option to the option group.
Why it's wrong here
The option group does not have a setting to enforce SSL; it is handled by the parameter group.
- ✓
Set the 'rds.force_ssl' parameter to 1 in the DB parameter group.
Why this is correct
This parameter forces SSL connections to the SQL Server DB instance.
- ✗
Change the DB subnet group to a public subnet.
Why it's wrong here
Subnet selection does not enforce SSL.
Visual reference
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 20, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.