AWS Certified Solutions Architect - Professional / Question #643 of 529

Question #643

A company has an on-premises monitoring solution using a MySQL database for event persistence. The database struggles to handle increasing data volumes and frequently encounters storage limitations.

The company aims to implement a hybrid solution with a pre-established VPN connection between its network and AWS. The solution must include the following:

- Fully managed AWS services to reduce operational overhead.
- An auto-scaling buffer requiring no administrative effort to handle fluctuating data throughput.
- A visualization tool for near-real-time dashboards to monitor events.
- Compatibility with semi-structured JSON data and evolving schemas.

Which combination of components will meet these requirements? (Choose two.)

A

Use Amazon Kinesis Data Firehose to buffer events. Deploy an AWS Lambda function to process and transform the data.

B

Create an Amazon Kinesis data stream to buffer events. Deploy an AWS Lambda function to process and transform the data.

C

Configure an Amazon Aurora MySQL DB cluster to ingest events. Use Amazon QuickSight to build near-real-time dashboards from the database.

D

Use Amazon OpenSearch Service (Amazon OS) to store events. Utilize the integrated Kibana interface to create near-real-time visualizations.

E

Configure an Amazon DocumentDB cluster to ingest events. Use Amazon QuickSight to visualize data from the database in near-real time.

Explanation

The requirements are met by:
- A: Kinesis Data Firehose is fully managed, auto-scales, and buffers data. Lambda processes data without administrative effort.
- D: OpenSearch Service stores semi-structured JSON data, supports evolving schemas, and Kibana provides near-real-time dashboards.

Why others are incorrect:
- B: Kinesis Data Streams requires manual shard management, violating the 'no administrative effort' requirement.
- C: Aurora MySQL is relational and less suited for semi-structured JSON/schema evolution. QuickSight lacks real-time capabilities compared to Kibana.
- E: DocumentDB handles JSON, but QuickSight isn't optimized for near-real-time dashboards like Kibana.

Key Points:
1. Use serverless/fully managed services (Firehose, Lambda, OpenSearch).
2. Prioritize auto-scaling and schema flexibility for semi-structured data.
3. Kibana (OpenSearch) is better for real-time visualization than QuickSight.

Answer

The correct answer is: AD