A solution architect is designing a relational database solution for an application. Requirements specify automated backups and point-in-time recovery ability. What database storage engines should the solution architect consider (choose two)?

Answer options:

A.InnoDB
B.RocksDB
C.XtraDB
D.Aria
E.MyISAM

Answer: A and C
Option A is CORRECT because the InnoDB storage engine supports automated backups on RDS MySQL and RDS MariaDB.Option B is incorrect because the RocskDB storage engine is not supported on Amazon RDS.
Option C is CORRECT because the XtraDB storage engine supports automated backups on RDS Maria DB.Option D is incorrect because the Aria storage engine for RDS MariaDB does not support automated backups.
Option E is incorrect because the MyISAM storage engine for RDS MySQL does not support automated backups.
Reference:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html