AWS Certified Database – Specialty — Question 190

A retail company runs its production database on Amazon RDS for SOL Server. The company wants more flexibility in backing up and restoring the database. A database specialist needs to create a native backup and restore strategy. The solution must take native SQL Server backups and store them in a highly scalable manner.

Which combination of stops should the database specialist take to meet those requirements? (Choose three.)

Answer options

• A. Set up an Amazon S3 destination bucket. Establish a trust relationship with an IAM role that includes permissions for Amazon RDS.
• B. Set up an Amazon FSx for Windows File Server destination file system. Establish a trust relationship with an IAM role that includes permissions for Amazon RDS.
• C. Create an option group. Add the SQLSERVER_BACKUP_RESTORE option to the option group
• D. Modify the existing default option group. Add the SQLSERVER_BACKUP_RESTORE option to the option group
• E. Back up the database by using the native BACKUP DATABASE TSQL command. Restore the database by using the RESTORE DATABASE TSQL command.
• F. Back up the database by using the rds_backup_database stored procedure. Restore the database by using the rds_restore_database stored procedure.

Correct answer: A, C, F

Explanation

The correct steps involve setting up an S3 bucket and creating an option group with the SQLSERVER_BACKUP_RESTORE option, which allows native backups and restores to be performed. Using the rds_backup_database and rds_restore_database stored procedures is also a valid approach for Amazon RDS, but the question specifies a native backup strategy, hence option F is included. Options B, D, and E either do not align with the native backup requirement or involve incorrect methods for this scenario.