Which AWS service or feature will help automate and achieve this objective?
AWS Systems Manager Parameter Store
DB parameter group
AWS Config
AWS Secrets Manager
Explanations:
AWS Systems Manager Parameter Store is used to store configuration data, such as secrets or application settings, but it doesn’t directly manage database configurations or apply changes to instances automatically.
DB parameter groups in Amazon RDS allow administrators to manage database configurations in a systematic way. Changes made to a DB parameter group are automatically applied to all RDS instances that are associated with that group, which fits the requirement perfectly.
AWS Config monitors and records configuration changes for AWS resources but does not directly manage or apply changes to RDS database configurations. It is not designed for automatically applying configuration updates to resources.
AWS Secrets Manager is primarily used to store and manage secrets like database credentials, API keys, etc. It does not handle database parameter configuration or automate their changes across RDS instances.