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 native
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #279. The question stem and answer options stay visible for context.
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
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.