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 questionsTo 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.
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.
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).
Keep practicing
Take the free SOA-C02 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SOA-C02 practice questions
- Question 1[Monitoring, Reporting, and Automation] A SysOps administrator needs to design a high-tra…
- Question 2[Deployment, Provisioning, and Automation] A company is using an Amazon EC2 Auto Scaling …
- Question 3[Security and Compliance] A company migrates a write-once, read-many (WORM) drive to an A…
- Question 4[Monitoring, Reporting, and Automation] A SysOps administrator must ensure that all of a …
- Question 5[Security and Compliance] The SysOps administrator needs to configure a website for Cloud…
- Question 6[Security and Compliance] A company has an AWS Config rule that identifies open SSH ports…
