SOA-C02 practice question 9 of 10

[Monitoring, Reporting, and Automation] A company is hosting applications on Amazon EC2 instances. The company is hosting a database on an Amazon RDS for PostgreSQL DB instance. The company requires all connections to the DB instance to be encrypted. What should a SysOps administrator do to meet this requirement?

Full set: 557 questions
Answer options
A: Allow SSL connections to the database by using an inbound security group rule.
B: Encrypt the database by using an AWS Key Management Service (AWS KMS) encryption key.
C: Enforce SSL connections to the database by using a custom parameter group. Correct answer
D: Patch the database with SSL/TLS by using a custom PostgreSQL extension.
Correct Answer:
C. Enforce SSL connections to the database by using a custom parameter group.
Explanation

To mandate that all incoming connections to an Amazon RDS for PostgreSQL database are strictly encrypted in transit via SSL/TLS, a SysOps administrator must configure and apply a custom DB parameter group. Within this specific custom parameter group, the operational parameter strictly named rds.force_ssl must be configured with a value set to 1 (or true). After this custom parameter group is correctly associated with the PostgreSQL RDS instance and the instance is rebooted to apply changes, the database engine will permanently reject any unencrypted TCP connection attempts. This built-in configuration explicitly enforces mandated transport-layer encryption without requiring manual infrastructure patching or custom extension deployments overhead.

Why Incorrect

A. Security groups exclusively control network traffic at the IP address and port layer (e.g., port 5432); they cannot inspect application protocol traffic or enforce encryption layer characteristics.
B. AWS Key Management Service (AWS KMS) provides encryption keys utilized to secure database storage volumes at rest, not to enforce SSL/TLS encryption for network data in transit.
D. Amazon RDS is a fully managed service that natively provides SSL enforcement via standard parameter groups; applying manual patches or arbitrary PostgreSQL OS-level extensions is unsupported.

References

Amazon Relational Database Service User Guide. Section: "Securing Amazon RDS connections -> Using SSL/TLS to encrypt a connection to a DB instance." Document ID: AWS-RDS-UG-2023.

Amazon Relational Database Service User Guide for PostgreSQL. Section: "Requiring an SSL connection to an Amazon RDS for PostgreSQL DB instance." (Specifies setting the rds.force_ssl parameter).

Scroll to Top