AWS Certified Database – Specialty — Question 342

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?

Answer options

• A. Use Amazon Redshift for relational data. Use Amazon DynamoDB for JSON data
• B. Use Amazon Redshift for relational data and JSON data.
• C. Use Amazon RDS for relational data. Use Amazon Neptune for JSON data
• D. Use Amazon Redshift for relational data. Use Amazon S3 for JSON data.

Correct answer: B

Explanation

Amazon Redshift natively supports both structured relational data and semi-structured JSON data (using the SUPER data type), allowing the company to perform unified advanced analytics and ETL workloads in a single service. Splitting the data across multiple services like Amazon DynamoDB, Amazon Neptune, or Amazon S3 increases architectural complexity and operational overhead. Therefore, utilizing Amazon Redshift for both data types offers the most operationally efficient solution.