Parameter groups and option groups in AWS - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a DB parameter group in AWS RDS.

AWS

aws rds create-db-parameter-group --db-parameter-group-name [1] --db-parameter-group-family mysql8.0 --description "My custom parameter group"

Drag options to blanks, or click blank then click option'

Amydbparamgroup

Bdefault

Crdsparamgroup

Dcustomgroup

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'default' which is reserved for AWS default groups.

Using names with spaces or special characters.

The --db-parameter-group-name must be a unique name you choose for your parameter group, such as mydbparamgroup.

2fill in blank

medium

Complete the code to add an option to an option group.

AWS

aws rds add-option-to-option-group --option-group-name myoptiongroup --options Name=[1] --major-engine-version 12.00

Drag options to blanks, or click blank then click option'

APOSTGRESQL_LOGGING

BSQLSERVER_BACKUP_RESTORE

CMYSQL_ENCRYPTION

DORACLE_AUDIT

Attempts:

3 left

💡 Hint

Common Mistakes

Using options not supported by the engine version.

Misspelling the option name.

The option SQLSERVER_BACKUP_RESTORE is a valid option for SQL Server option groups.

3fill in blank

hard

Fix the error in the code to modify a DB parameter group to set a parameter value.

AWS

aws rds modify-db-parameter-group --db-parameter-group-name mydbparamgroup --parameters ParameterName=[1],ParameterValue=100,ApplyMethod=immediate

Drag options to blanks, or click blank then click option'

Amax_connections=100

Bmax_connections:100

Cmax_connections

Dmax_connections 100

Attempts:

3 left

💡 Hint

Common Mistakes

Including the value assignment inside the string.

Using colon or space instead of equals sign.

The --parameters argument expects a JSON or key-value pair without the value assignment inside the string. The correct format is to specify the parameter name and value separately.

4fill in blank

hard

Fill both blanks to create an option group and add an option to it.

AWS

aws rds create-option-group --option-group-name [1] --engine-name [2] --major-engine-version 12.00 --option-group-description "Test option group"

Drag options to blanks, or click blank then click option'

Amyoptiongroup

Bmysql

Csqlserver-ee

Dpostgres

Attempts:

3 left

💡 Hint

Common Mistakes

Using engine names that don't match the option group.

Using default or reserved names for the option group.

The option group name is myoptiongroup and the engine name is sqlserver-ee for SQL Server Enterprise Edition.

5fill in blank

hard

Fill all three blanks to modify a DB parameter group by setting a parameter name, value, and apply method.

AWS

aws rds modify-db-parameter-group --db-parameter-group-name mydbparamgroup --parameters ParameterName=[1],ParameterValue=[2],ApplyMethod=[3]

Drag options to blanks, or click blank then click option'

Amax_allowed_packet

B16777216

Cimmediate

Dpending-reboot

Attempts:

3 left

💡 Hint

Common Mistakes

Using invalid parameter names.

Using incorrect apply methods.

The parameter max_allowed_packet is set to 16777216 bytes and applied immediately.