DBS-C01 · Question #279
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…
The correct answer is A. Set up an Amazon S3 destination bucket. Establish a trust relationship with an IAM role that C. Create an option group. Add the SQLSERVER_BACKUP_RESTORE option to the option group F. Back up the database by using the rds_backup_database stored procedure. Restore the. https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.B ackupRestore.html https://aws.amazon.com/premiumsupport/knowledge-center/native-backup-rds-sql-server/
Question
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.)
Options
- ASet up an Amazon S3 destination bucket. Establish a trust relationship with an IAM role that
- BSet up an Amazon FSx for Windows File Server destination file system. Establish a trust
- CCreate an option group. Add the SQLSERVER_BACKUP_RESTORE option to the option group
- DModify the existing default option group. Add the SQLSERVER_BACKUP_RESTORE option to
- EBack up the database by using the native BACKUP DATABASE TSQL command. Restore the
- FBack up the database by using the rds_backup_database stored procedure. Restore the
How the community answered
(40 responses)- A83% (33)
- B3% (1)
- D10% (4)
- E5% (2)
Explanation
https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.B ackupRestore.html https://aws.amazon.com/premiumsupport/knowledge-center/native-backup-rds-sql-server/
Topics
Community Discussion
No community discussion yet for this question.