AWS Certified Solutions Architect – Professional (SAP-C02) — Question 111
A company has an on-premises monitoring solution using a PostgreSQL database for persistence of events. The database is unable to scale due to heavy ingestion and it frequently runs out of storage.
The company wants to create a hybrid solution and has already set up a VPN connection between its network and AWS. The solution should include the following attributes:
• Managed AWS services to minimize operational complexity.
• A buffer that automatically scales to match the throughput of data and requires no ongoing administration.
• A visualization tool to create dashboards to observe events in near-real time.
• Support for semi-structured JSON data and dynamic schemas.
Which combination of components will enable the company to create a monitoring solution that will satisfy these requirements? (Choose two.)
Answer options
- A. Use Amazon Kinesis Data Firehose to buffer events. Create an AWS Lambda function to process and transform events.
- B. Create an Amazon Kinesis data stream to buffer events. Create an AWS Lambda function to process and transform events.
- C. Configure an Amazon Aurora PostgreSQL DB cluster to receive events. Use Amazon QuickSight to read from the database and create near-real-time visualizations and dashboards.
- D. Configure Amazon Elasticsearch Service (Amazon ES) to receive events. Use the Kibana endpoint deployed with Amazon ES to create near-real-time visualizations and dashboards.
- E. Configure an Amazon Neptune DB instance to receive events. Use Amazon QuickSight to read from the database and create near-real-time visualizations and dashboards.
Correct answer: A, D
Explanation
The correct answers are A and D. Amazon Kinesis Data Firehose is a fully managed service that buffers incoming streaming data and automatically scales, which meets the requirement for minimal operational complexity. It pairs well with AWS Lambda for processing. Amazon Elasticsearch Service allows for dynamic schema support and offers Kibana for real-time visualization, fulfilling the requirements for dashboards. Options B, C, and E do not fully meet the operational simplicity or dynamic schema needs as effectively as A and D.