Parameter groups and option groups in AWS - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a parameter group in AWS RDS?

A parameter group is like a settings file for your database. It controls how the database behaves by setting configuration options such as memory usage or timeouts.

beginner

What is an option group in AWS RDS?

An option group lets you add extra features or tools to your database, like enabling encryption or adding support for certain extensions.

intermediate

How do parameter groups differ from option groups?

Parameter groups change how the database works internally (settings), while option groups add extra capabilities or plugins to the database.

intermediate

Can you modify a parameter group after creating an RDS instance?

Yes, you can change a parameter group anytime. Changes may require a database restart to take effect.

beginner

Why would you use option groups in AWS RDS?

To enable additional database features not included by default, like Oracle's TDE encryption or SQL Server's audit feature.

What does a parameter group control in AWS RDS?

A Adding extra database features

B Database configuration settings

C User access permissions

D Backup schedules

Parameter groups control the database's internal configuration settings.

Which AWS RDS feature allows you to add plugins or extra tools to your database?

A Option group

B Parameter group

C Security group

D Subnet group

Option groups let you add extra features or tools to your database.

If you want to change the memory allocation of your RDS database, which should you modify?

A Parameter group

B Option group

C Security group

D IAM role

Memory allocation is controlled by parameters in the parameter group.

True or False: You must restart your RDS instance for all parameter group changes to take effect.

A Only for option groups

B Only for security groups

C True

D False

Not all parameter changes require a restart; dynamic parameters apply immediately, while static ones require a reboot.

Which group would you use to enable Oracle Transparent Data Encryption (TDE) in RDS?

A Parameter group

B Security group

C Option group

D Subnet group

Option groups enable extra features like Oracle TDE.

Explain the purpose of parameter groups and option groups in AWS RDS and how they differ.

Think of parameter groups as settings and option groups as add-ons.

Describe a scenario where you would need to modify a parameter group and another where you would use an option group.

Settings vs features.