DEA-C01 Practice Question 44: AppFlow Salesforce Ingestion

AWS Certified Data Engineer – Associate (DEA-C01) · Test 5 · question 4 of 10

Data Ingestion and Transformationeasy

An analytics team needs Salesforce opportunity records delivered to an Amazon S3 data lake once a day and registered in the AWS Glue Data Catalog. Nobody on the team has worked with the Salesforce APIs, and the company wants to avoid writing and maintaining integration code.

Which service should the data engineer use?

Show answer and explanation

Answer:

B. An Amazon AppFlow flow with Salesforce as the source and Amazon S3 as the destination, run on a daily schedule

Amazon AppFlow "is a fully-managed integration service that enables you to securely exchange data between software as a service (SaaS) applications, such as Salesforce, and AWS services, such as Amazon Simple Storage Service (Amazon S3) and Amazon Redshift." It is built for this job: you "create data flows to transfer data between a source and destination in minutes, without writing any code", and you "run flows on demand or on a schedule". It also covers the cataloging requirement directly; you can "catalog the data that you transfer to Amazon S3 in the AWS Glue Data Catalog."

Option A drags in an EC2 instance to patch, a third-party driver to license and maintain, and a Glue connection to configure, all to solve a problem a managed connector already solves.

Option C is the integration code the team wanted to avoid. OAuth refresh, pagination, API limit handling, incremental watermarks and retry logic all become the team's to own and debug.

Option D names a service that does not support this source. AWS DMS migrates and replicates relational and a specific set of non-relational databases; Salesforce is not an available source endpoint, so the task cannot be created.

Reference: What is Amazon AppFlow?

Practice Test 5 ›

Study guides for DEA-C01

AWS Developer Associate exam guide: DVA-C02 to DVA-C03AWS Developer Associate exam: DVA-C02 ends 30 November 2026 and DVA-C03 starts 1 December. What changes, which to sit, format, price and study plan.

How AWS Certification Exams Work: Scoring and RenewalHow AWS certification exams work: levels, booking, question types, unscored questions, scaled scores, pass marks, validity and how recertification works.

What Is Amazon RDS? Multi-AZ, Read Replicas and BackupsWhat is Amazon RDS? Engines, Multi-AZ, read replicas, backups, RDS Proxy, Aurora and pricing explained, with the traps that AWS exams set around each one.

Microsoft Fabric certification: DP-700 vs DP-600Microsoft Fabric certification means two exams, DP-600 and DP-700. Their roles, skills, format, cost in India, and which one to take first.

Databricks Data Engineer Associate vs AWS DEA-C01Databricks Data Engineer Associate vs AWS Certified Data Engineer – Associate - format, cost, topics and which one to take for your job, as of 2026.

Which AWS certification should you get? 2026 roadmapWhich AWS certification to get first, by role and experience, with each exam's status in October 2026, what is changing, and prices in USD and INR.

What Is AWS Glue? Data Catalog, Crawlers and ETL JobsWhat is AWS Glue? The Data Catalog, crawlers, ETL jobs and DPUs, workflows, streaming, job bookmarks, Flex and Data Quality, plus the traps AWS exams set.