An application uses AWS RDS SQL Server instance as the database backend. A DBA wishes to take a SQL Server native backup of a database. What action must he perform to enable this requirement?

Answer options:

A.Create a new Option Group and configure SQLSERVER_BACKUP_RESTORE option.Associate the option group with the DB instance.
B.Create a new DB Parameter Group and configure the SQLSERVER_BACKUP_RESTORE system parameter.Associate the DB Parameter Group with the DB instance.
C.Use the AWS CLI create-db-snapshot command to create a backup of the RDS instance.
D.Ensure that RDS automated backup feature is configured on the RDS instance.

Answer: A
Option A is CORRECT because performing SQL Server native backup using .bak files is a SQL Server specific functionality. To enable this capability, SQLSERVER_BACK_RESTORE option must be configured. To add this functionality to an RDS SQL Server instance, you must create a new custom Option Group and configure the SQLSERVER_BACKUP_RESTORE setting, and then associate the new Option Group with the RDS instance.
Option B is incorrect because DB Parameter Groups are used for setting DB system parameters.In this case, we want to enable a specific feature available for a particular RDS engine (SQL Server).To do this, we must use and configure Option Groups.
Option C is incorrect because create-db-snapshot creates a storage volume snapshot of the entire RDS database instance. It does not perform a SQL Server native backup of a specific database.
Option D is incorrect because the automated backup feature creates automated volume snapshots of the RDS database instance. It does not perform a SQL Server native backup of a specific database.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html