DEA-C01 practice question: Batch ingestion and migration with DMS and AppFlow (2 of 2)
Data Ingestion and Transformation A free question from our original DEA-C01 practice exam. Try it, then open the answer to see why each option is right or wrong.
A solar installer tracks installation jobs and customer accounts in a Salesforce org. The data team needs a nightly copy of changed records in an S3 bucket, with the data encrypted under a customer managed AWS KMS key.
The team has three engineers, no existing Salesforce integration code, and a goal of as little custom code as possible. Only records changed since the last run should be transferred, and the copy must finish in an overnight window.
Which solution meets these requirements?
Choose one answer.
AA. Write a Lambda function that pages through the Salesforce REST API with a stored OAuth token, keeps its own high-water mark in DynamoDB, and writes the results to S3.
BB. Use AWS DMS with a Salesforce source endpoint and an S3 target, running as a continuous change data capture task.
CC. Create an Amazon AppFlow flow from Salesforce to S3 on a nightly schedule, with incremental transfer and a customer managed KMS key for encryption.
DD. Create an AWS DataSync task with a Salesforce source location and an S3 destination, scheduled nightly with SSE-KMS on the bucket.
Show the answer and explanation
Answer: C
A. Wrong: This can work, but the team would have to build and maintain API paging, token refresh and change tracking. The team wants minimal custom code, so this option adds more operating work than needed.
B. Wrong: AWS DMS replicates from database engines, and Salesforce is not one of its sources. A continuous task would also run all day, which does not match a nightly window.
C. Right: Correct. AppFlow has a managed Salesforce connector, so the flow needs no integration code. A schedule-triggered flow with incremental transfer moves only records added or changed since the last successful run, and AppFlow can encrypt the S3 output with a customer managed KMS key. Learn more: Flow triggers (opens in a new tab)
D. Wrong: DataSync moves files and objects between storage systems such as NFS, SMB, HDFS and object stores. It has no Salesforce connector, so it cannot read records from the org or tell which ones changed. Learn more: What is AWS DataSync? (opens in a new tab)
Explanation
AppFlow is a managed integration service with built-in SaaS connectors, so the team avoids writing and maintaining Salesforce integration code. A schedule-triggered flow can run nightly, use incremental transfer to move only changed records, and encrypt the output with a customer managed KMS key. The custom Lambda approach, DMS and DataSync each fail one requirement.
Want more on Batch ingestion and migration with DMS and AppFlow? The 5 full-length practice sets have 10 more Batch ingestion and migration with DMS and AppFlow questions, 325 in all, none of them in the free exam. One payment of $14.99, no subscription. See the practice sets →