A Solution Architect is designing a migration strategy from on-prem MySQL to Amazon Aurora. An assessment of features compatibility must be performed. Which engine is used by Amazon Aurora and must be taken into consideration during this analysis?

Answer options:

A.InnoDB
B.MyISAM
C.MySQL 5.4
D.XtraDB

Answer: A
Option A is CORRECT because Amazon Aurora only supports InnoDB MySQL compatible storage engine.
Option B is incorrect because Amazon Aurora does not support the MyISAM storage engine.
Option C is incorrect because MySQL 5.4 is a MySQL version. Amazon Aurora supports features in MySQL 5.6 and 5.7.Further, versions prior to MySQL 5.5 used MyISAM storage engine, not compatible with Amazon Aurora.
Option D is incorrect because XtraDB is a storage engine for MariaDB.Reference:
https://aws.amazon.com/rds/aurora/faqs/