Courseiva

DEA-C01 Data Ingestion and Transformation Practice Question

A data engineer needs to ingest data from a SaaS application (Salesforce) into Amazon S3 on a daily basis. Which TWO AWS services can be used for this purpose? (Choose TWO.)

⚠ Common exam trap

It's easy for candidates to confuse AWS DataSync's ability to sync from cloud sources (like EFS) with SaaS applications, but DataSync does not support Salesforce or other SaaS APIs natively.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

AWS Glue

Amazon AppFlow (option E) is purpose-built for ingesting data from SaaS applications like Salesforce into AWS destinations such as Amazon S3, supporting scheduled daily flows without custom code. AWS Glue (option D) can also perform this ingestion by using its Salesforce connector within Glue ETL jobs or Glue Studio, writing the extracted data to S3 on a schedule. AWS DataSync (A) is designed for migrating and syncing file data between on-premises storage and AWS, not for SaaS API ingestion. Amazon Kinesis Data Streams (B) is a real-time streaming service that requires custom producers and does not natively connect to Salesforce. AWS Transfer Family (C) only provides managed SFTP, FTPS, and FTP endpoints into S3 or EFS, which does not address SaaS application ingestion.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    AWS DataSync

    Why it's wrong here

    AWS DataSync moves files between on-premises storage, other clouds and AWS storage services; it has no native Salesforce connector, so it cannot pull SaaS records. It is tempting because it handles scheduled, incremental transfers into Amazon S3, which would be correct for migrating an on-premises NFS or SMB file share.

  • ✗

    Amazon Kinesis Data Streams

    Why it's wrong here

    Kinesis Data Streams ingests streaming records from producers using the Kinesis API or KPL; Salesforce does not write to it natively, so daily batch extraction is unsupported. It is tempting because it lands continuous event data, which would be correct for real-time clickstream or telemetry ingestion.

  • ✗

    AWS Transfer Family

    Why it's wrong here

    AWS Transfer Family exposes SFTP, FTPS and FTP endpoints into Amazon S3; Salesforce does not push data over those protocols, so ingestion would fail. It is tempting because it schedules file drops into S3, which would be correct for a partner or legacy system delivering files by SFTP.

  • ✓

    AWS Glue

    Why this is correct

    AWS Glue provides built-in Salesforce connectors and can run on a daily schedule, extracting records and writing them directly to Amazon S3. This satisfies the daily ingestion requirement without managing servers, complementing AppFlow as the second valid service.

  • ✓

    Amazon AppFlow

    Why this is correct

    Amazon AppFlow is purpose-built for SaaS-to-AWS ingestion, offering a native Salesforce connector that transfers data into Amazon S3 on a schedule. It meets the daily ingestion constraint with no custom code, pairing with AWS Glue as the second valid service.

Quick reference

AWS S3 Storage Class Comparison

Storage ClassMin DurationRetrievalUse Case
S3 StandardNoneImmediateFrequently accessed data
S3 Standard-IA30 daysImmediateInfrequent access, rapid retrieval
S3 One Zone-IA30 daysImmediateNon-critical infrequent data
S3 Intelligent-TieringNoneImmediate–hoursUnknown or changing access patterns
S3 Glacier Instant90 daysMillisecondsArchive with instant retrieval
S3 Glacier Flexible90 daysMinutes–hoursArchive, flexible retrieval
S3 Glacier Deep Archive180 daysHoursLong-term compliance archive

About these practice questions

This DEA-C01 question is part of Courseiva's 1,321-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DEA-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DEA-C01 exam.