Exam AWS Certified Database - Specialty topic 1 question 245 discussion

https://docs.aws.amazon.com/redshift/latest/dg/super-overview.html. It's B.

B because: Amazon Redshift can handle both data types efficiently: Native support for relational data SUPER data type for JSON data Single service means: Simpler operations One system to monitor One set of backups One security model Well-suited for existing workloads: Native support for ETL Built for advanced analytics SQL interface familiar to SQL Server users

B. Use Amazon Redshift "By using semistructured data support in Amazon Redshift, you can ingest and store semistructured data in your Amazon Redshift data warehouses. Using the SUPER data type and PartiQL language, Amazon Redshift expands data warehouse capability to integrate with both SQL and NoSQL data sources. This way, Amazon Redshift enables efficient analytics on relational and semistructured stored data such as JSON." https://docs.aws.amazon.com/redshift/latest/dg/super-overview.html

Use the SUPER data type if you need to insert or update small batches of JSON data with low latency https://docs.aws.amazon.com/redshift/latest/dg/super-overview.html#:~:text=Use%20the%20SUPER%20data%20type%20if%20you%20need%20to%20insert%20or%20update%20small%20batches%20of%20JSON%20data%20with%20low%20latency

https://docs.aws.amazon.com/redshift/latest/dg/json-functions.html A is the answer . AWS itself is recommending not to use Redshift for JSON . It recommends using SUPER

requirement is complex analytics which is never supported by DynamoDB...

B. By using semistructured data support in Amazon Redshift, you can ingest and store semistructured data in your Amazon Redshift data warehouses. Using the SUPER data type and PartiQL language, Amazon Redshift expands data warehouse capability to integrate with both SQL and NoSQL data sources. This way, Amazon Redshift enables efficient analytics on relational and semistructured stored data such as JSON.

https://docs.aws.amazon.com/redshift/latest/dg/super-overview.htm

B is correct I would say. I wouldn't use DynamoDB for advanced analytics, so that takes out A

A is correct

ETL and advanced analytics - Redshift, JSON Data for sure DynamoDB. It's A.