QuestionQ9
Data Ingestion and TransformationA company needs to analyze sales records that it stores in a MySQL database and correlate those records with sales opportunities identified in Salesforce.
The company receives 2 GB of sales records each day and has 100 GB of identified sales opportunities. A data engineer must develop a process to analyze and correlate the sales records and sales opportunities. The process must run once every night.
Which solution meets these requirements with the LEAST operational overhead?
- A Use Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to fetch both datasets. Use AWS Lambda functions to correlate the datasets. Use AWS Step Functions to orchestrate the process.
- B 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 the sales opportunities. Use Amazon Managed Workflows for Apache Airflow (Amazon MWAA) to orchestrate the process.
- 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 the process.
- D Use Amazon AppFlow to fetch sales opportunities from Salesforce. Use Amazon Kinesis Data Streams to fetch sales records from the MySQL database. Use Amazon Managed Service for Apache Flink to correlate the datasets. Use AWS Step Functions to orchestrate the process.
Community Discussion