SAP-C02 Question 318
Select 2A company is building an analytics platform to process and analyze structured, semi-structured, and unstructured data. The solution must provide low-latency querying for structured data, allow full-text search for unstructured data, and enable fast processing of time-series data. Which combination of AWS purpose-built databases should the company use to meet these requirements?
- A
Amazon Aurora for structured data, Amazon OpenSearch Service for unstructured data, Amazon Timestream for time-series data
- B
Amazon DynamoDB for structured data, Amazon Neptune for unstructured data, Amazon ElastiCache for time-series data
- C
Amazon RDS for structured data, Amazon OpenSearch Service for unstructured data, Amazon Timestream for time-series data
- D
Amazon Redshift for structured data, Amazon OpenSearch Service for unstructured data, Amazon Timestream for time-series data
- E
Amazon DynamoDB for structured data, Amazon OpenSearch Service for unstructured data, Amazon RDS for time-series data
Show answer and explanation
Correct answers: A, D
Explanation
Purpose-built databases are optimized for specific use cases. In this scenario, Amazon Aurora or Amazon Redshift are suited for analyzing structured data, Amazon OpenSearch Service is ideal for full-text search on unstructured data, and Amazon Timestream is designed for time-series data. Choosing the right database for each workload ensures optimal performance and cost-efficiency.
- A. Correct.
Correct. Amazon Aurora is a relational database service suited for structured data with low-latency querying, Amazon OpenSearch Service provides full-text search capabilities for unstructured data, and Amazon Timestream is purpose-built for time-series data.
- B. Incorrect.
Incorrect. While DynamoDB is a NoSQL database, it is not ideal for structured data. Additionally, Amazon Neptune is a graph database and not suited for unstructured data, and ElastiCache is designed for in-memory caching rather than time-series data.
- C. Incorrect.
Incorrect. While RDS can handle structured data, it is not optimized for analytics at scale compared to Aurora or Redshift. This option does not address the specific requirements for low-latency querying and time-series data.
- D. Correct.
Correct. Amazon Redshift is a data warehouse optimized for structured data analytics, Amazon OpenSearch Service provides full-text search for unstructured data, and Amazon Timestream is specifically designed for time-series data.
- E. Incorrect.
Incorrect. DynamoDB is a NoSQL database and not ideal for structured data analytics. Additionally, RDS is not designed for time-series data.