Home / Amazon / SAA-C01 / Question 331

A company will run different data analytics jobs on large petabyte-scale datasets, using standard SQL and existing business intelligence tools. The data is mostly structured, but part of the data is unstructured and resides in Amazon S3.What technology should be used to support this use case?

• A. An Amazon Aurora database cluster with 15 replicas distributed across Availability Zones.

• B. Amazon Redshift with Amazon Redshift Spectrum.

• C. Amazon DynamoDB with Amazon DynamoDB Accelerator (DAX).

• D. Amazon ElastiCache for Redis with cluster mode enabled.

For data warehousing, Amazon Redshift provides the ability to run complex, analytic queries against petabytes of structured data, and includes Redshift Spectrum that runs SQL queries directly against Exabytes of structured or unstructured data in S3 without the need for unnecessary data movement.https://aws.amazon.com/big-data/datalakes-and-analytics/