nerdexam
AmazonAmazon

DBS-C01 · Question #279

DBS-C01 Question #279: Real Exam Question with Answer & Explanation

The correct answer is A: Set up an Amazon S3 destination bucket. Establish a trust relationship with an IAM role that. 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/

Submitted by takeshi77· Mar 6, 2026Management and Operations

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

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

#RDS for SQL Server#native backup#S3#option groups#stored procedures

Community Discussion

No community discussion yet for this question.

Full DBS-C01 PracticeBrowse All DBS-C01 Questions