A company uses an Amazon Aurora PostgreSQL DB cluster for applications in a single AWS Region. The company's database team must monitor all data activity on all the databases.
Which solution will achieve this goal?
A.
Set up an AWS Database Migration Service (AWS DMS) change data capture (CDC) task. Specify the Aurora DB cluster as the source. Specify Amazon Kinesis Data Firehose as the target. Use Kinesis Data Firehose to upload the data into an Amazon OpenSearch Service cluster for further analysis.
B.
Start a database activity stream on the Aurora DB cluster to capture the activity stream in Amazon EventBridge. Define an AWS Lambda function as a target for EventBridge. Program the Lambda function to decrypt the messages from EventBridge and to publish all database activity to Amazon S3 for further analysis.
C.
Start a database activity stream on the Aurora DB cluster to push the activity stream to an Amazon Kinesis data stream. Configure Amazon Kinesis Data Firehose to consume the Kinesis data stream and to deliver the data to Amazon S3 for further analysis.
D.
Set up an AWS Database Migration Service (AWS DMS) change data capture (CDC) task. Specify the Aurora DB cluster as the source. Specify Amazon Kinesis Data Firehose as the target. Use Kinesis Data Firehose to upload the data into an Amazon Redshift cluster. Run queries on the Amazon Redshift data to determine database activities on the Aurora database.
For those who think the correct option is B: "The Aurora DB cluster sends activities to an Amazon Kinesis data stream in near real time." It does NOT send to EventBridge.
https://docs.aws.amazon.com/pt_br/AmazonRDS/latest/AuroraUserGuide/DBActivityStreams.html
B is ans :
Here's why this solution is the most suitable:
Direct integration: Database activity streams natively integrate with EventBridge, streamlining the process of capturing and routing events.
Rich event filtering: EventBridge offers powerful filtering capabilities, allowing the database team to selectively monitor specific events or patterns of interest.
Flexible delivery: EventBridge can trigger various targets, including Lambda functions, which provide the ability to process and store events in S3 for further analysis.
Serverless architecture: Lambda functions eliminate the need to manage servers, reducing operational overhead and scaling automatically to handle event volume.
Cost-effective storage: S3 offers durable and cost-effective storage for long-term analysis of database activity logs.
GPT: Option A and D are incorrect because AWS DMS's Change Data Capture (CDC) functionality captures changes made at the database level, not data activity.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
elanelans
Highly Voted 1 year, 10 months agoJoeTromundo
Most Recent 6 months, 3 weeks agothotwielder
1 year, 3 months agoduriselvan
1 year, 4 months agohelloworldabc
8 months, 1 week agocareer360guru
1 year, 5 months agoggrodskiy
1 year, 9 months agoNikkyDicky
1 year, 9 months agoSmileyCloud
1 year, 10 months agoSkyZeroZx
1 year, 10 months agoshree2023
1 year, 10 months agogd1
1 year, 10 months agoMoussaNoussa
1 year, 10 months agobhanus
1 year, 10 months ago