A company uses an on-premises Microsoft SQL Server database to host relational and JSON data and to run daily ETL and advanced analytics.The company wants to migrate the database to the AWS Cloud.Database specialist must choose one or more AWS services to run the company’s workloads.
Which solution will meet these requirements in the MOST operationally efficient manner?
Use Amazon Redshift for relational data. Use Amazon DynamoDB for JSON data
Use Amazon Redshift for relational data and JSON data.
Use Amazon RDS for relational data. Use Amazon Neptune for JSON data
Use Amazon Redshift for relational data. Use Amazon S3 for JSON data.
I evaluate that the answer is:
Use Amazon Redshift for relational data and JSON data.