What should a solutions architect recommend as replacement database?
Use Amazon Aurora with Multi-AZ Aurora Replicas and restore from mysqldump for the test database.
Use Amazon Aurora with Multi-AZ Aurora Replicas and restore snapshots from Amazon RDS for the test database.
Use Amazon RDS for MySQL with a Multi-AZ deployment and read replicas, and use the standby instance for the test database.
Use Amazon RDS for SQL Server with a Multi-AZ deployment and read replicas, and restore snapshots from RDS for the test database.
Explanations:
Amazon Aurora does not support Microsoft SQL Server, so this option is not applicable for migrating from a SQL Server database.
Aurora does not support SQL Server. Even though Aurora with Multi-AZ is an option, the use of RDS snapshots is not suitable as a replacement for SQL Server.
Amazon RDS for MySQL is not an ideal replacement for Microsoft SQL Server as it might require significant changes to the application. Additionally, using the standby instance for the test database isn’t the best practice, as the standby instance is intended for failover.
Amazon RDS for SQL Server with Multi-AZ deployment and read replicas provides the best option for migrating from SQL Server to AWS, offering high availability and elasticity, while also using snapshots to restore the test database without impacting production.