Considered Database Storage Engines |

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:

The two database storage engines that the solution architect should consider for automated backups and point-in-time recovery ability are InnoDB and XtraDB.

InnoDB is a transactional storage engine for MySQL and is the default engine used by Amazon RDS for MySQL. It provides reliable ACID-compliant transactions, automatic crash recovery, and support for foreign keys, making it a good option for applications that require data consistency and integrity. InnoDB also supports incremental backups and point-in-time recovery, which allows the database to be restored to a specific point in time, making it an ideal choice for applications that require data protection and recoverability.

XtraDB is a fork of the InnoDB storage engine and is designed to provide better performance and scalability than InnoDB. It offers all the features of InnoDB, including transaction support, crash recovery, and support for foreign keys, and also includes additional features such as improved concurrency control and buffer pool flushing. Like InnoDB, XtraDB supports incremental backups and point-in-time recovery, making it an excellent choice for applications that require data protection and recoverability.

RocksDB is a high-performance, key-value store that is optimized for solid-state drives (SSDs) and is not suitable for relational databases. Aria and MyISAM are both non-transactional storage engines that do not support ACID-compliant transactions or point-in-time recovery, making them unsuitable for applications that require data consistency, integrity, and recoverability.

In summary, the solution architect should consider InnoDB and XtraDB storage engines for automated backups and point-in-time recovery ability, as they provide reliable transactions, crash recovery, and support for foreign keys, while also supporting incremental backups and point-in-time recovery.