Question 430
Which service-to-requirement explanation best fits this situation: A business intelligence team wants to run large-scale structured analytical queries on consolidated data?
Explanation
Correct Answer
Redshift is designed for scalable analytic SQL warehousing rather than primary transactional OLTP workloads. This fits the situation: A business intelligence team wants to run large-scale structured analytical queries on consolidated data.
Incorrect Answers
Amazon RDS provides managed relational database engines. This does not address the need for A business intelligence team wants to run large-scale structured analytical queries on consolidated data. The appropriate Amazon Redshift applies because Redshift is designed for scalable analytic SQL warehousing rather than primary transactional OLTP workloads.
Amazon ElastiCache: ElastiCache supplies managed in-memory caching engines for high-speed access to frequently used data. This does not address the need for A business intelligence team wants to run large-scale structured analytical queries on consolidated data. The appropriate Amazon Redshift applies because Redshift is designed for scalable analytic SQL warehousing rather than primary transactional OLTP workloads.
Amazon DynamoDB provides managed key-value and document NoSQL storage. This does not address the need for A business intelligence team wants to run large-scale structured analytical queries on consolidated data. The appropriate Amazon Redshift applies because Redshift is designed for scalable analytic SQL warehousing rather than primary transactional OLTP workloads.