Which combination of stops should the database specialist take to meet those requirements?

By:
In: DBS-C01
Tagged:
With: 2 Comments
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.)

Set up an Amazon S3 destination bucket. Establish a trust relationship with an IAM role that includes permissions for Amazon RDS.

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.

Create an option group. Add the SQLSERVER_BACKUP_RESTORE option to the option group

Modify the existing default option group. Add the SQLSERVER_BACKUP_RESTORE option to the option group

Back up the database by using the native BACKUP DATABASE TSQL command. Restore the database by using the RESTORE DATABASE TSQL command.

Back up the database by using the rds_backup_database stored procedure. Restore the database by using the rds_restore_database stored procedure.

2026-03-27

2 Comments

  1. Diana
    Author

    From what I’ve seen, the answer is:
    Set up an Amazon S3 destination bucket. Establish a trust relationship with an IAM role that includes permissions for Amazon RDS.

  2. Tyler
    Author

    I sort that the answer is:
    Set up an Amazon S3 destination bucket. Establish a trust relationship with an IAM role that includes permissions for Amazon RDS.

Leave a Reply to Tyler Cancel reply

Your email address will not be published. Required fields are marked *

18 + fourteen =