AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 195

Question

A company wants to analyze sales records that the company stores in a MySQL database. The company wants to correlate the records with sales opportunities identified by Salesforce. The company receives 2 GB of sales records every day. The company has 100 GB of identified sales opportunities. A data engineer needs to develop a process that will analyze and correlate sales records and sales opportunities. The process must run once each night. Which solution will meet these requirements with the LEAST operational overhead?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Use Amazon AppFlow to fetch sales opportunities from Salesforce. Use AWS Glue to fetch sales records from the MySQL database. Correlate the sales records with sales opportunities. Use AWS Step Functions to orchestrate... Amazon RDS is a managed relational database that handles patching, backups and failover. AWS Step Functions coordinates multi-step workflows as a managed state machine. Amazon AppFlow securely transfers data between SaaS apps and AWS without code.

AWS Certified Data Engineer - Associate DEA-C01 — Question 195