AWS Certified Data Engineer Associate Study Guide

Appendix. Solutions to the Practice Questions

This appendix lists the solutions to the practice questions appearing at the end of Chapters 4–7 and the practice exam in Chapter 9.

Chapter 4

1. C: The zero-ETL integration between Salesforce and Redshift that AWS Glue provides is the most seamless, optimal-cost, and low-overhead solution for integrating Salesforce data into Amazon Redshift. AWS takes care of the heavy lifting of identifying new data from the source and continuously replicating it to the target Redshift. Where zero-ETL integrations are available, they are almost always the right solution.

2. C: Creating an S3 event notification that triggers the Lambda function directly when an S3 ObjectCreated event occurs, with a filter rule for .txt files, provides the most straightforward and least operationally complex solution for this requirement.

3. C: AWS Glue DataBrew offers a visual, low-code interface for designing data preparation workflows, making it ideal for handling the described data quality issues and transformations with minimal coding and operational overhead.

4. B: Amazon Data Firehose provides the most streamlined solution for consolidating real-time data from multiple AWS services and delivering it to Datadog with minimal operational overhead, offering built-in integrations and automatic scaling.

5. A: UNNEST_STRUCT is the function that solves the requirement here.

6. B: AWS DataSync is purpose-built for efficient, automated data transfer from on-premises to AWS, with change ...