Exam AWS Certified Database - Specialty topic 1 question 270 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 270
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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.)

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.

Show Suggested Answer

Suggested Answer: ACF 🗳️

by Sab at Nov. 30, 2022, 11:48 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

DanShone

1 year, 11 months ago

Selected Answer: ACF

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.BackupRestore.html

upvoted 1 times

...

Pranava_GCP

1 year, 11 months ago

Selected Answer: ACF

https://repost.aws/knowledge-center/native-backup-rds-sql-server ideally for C. to add below for a more complete process. associate the newly created option group with the DB instance.

upvoted 2 times

...

SamDDD

2 years, 1 month ago

Selected Answer: BCF

"highly scalable manner" - S3 max limit is 5TB. What about database that's 55TB+? Amazon FSx for Windows File Server limit is 64TB. rds_backup_database : @number_of_files – The number of files into which the backup will be divided (chunked). The maximum number is 10. 10 x5TB = 50TB of backup can be stored in S3

upvoted 1 times

Zdujgfr567783ff

2 years, 1 month ago

how would you initiate a backup to FSx from AWS RDS SQL Server? it does S3 only https://sqlbak.com/blog/how-to-backup-and-restore-amazon-rds-sql-server/#:~:text=Backup%201%20Once%20the%20SqlBak%20app%20is%20installed%2C,then%20click%20on%20the%20%E2%80%9CRun%20now%E2%80%9D%20button.%20

upvoted 3 times

...

Mardoyyy

2 years, 8 months ago

Selected Answer: ACF

default option group cannot be modified

upvoted 3 times

...

Sab

2 years, 8 months ago

ACF https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.BackupRestore.html https://aws.amazon.com/premiumsupport/knowledge-center/native-backup-rds-sql-server/

upvoted 3 times

...