Answer-first summary for fast verification
Answer: AWS Glue
Option A is the most appropriate choice for building a data pipeline that extracts data from a relational database and loads it into a data warehouse with incremental data loads and data consistency. AWS Glue is a fully managed ETL service that can extract data from various data sources, including relational databases, and load it into a data warehouse. Glue can handle incremental data loads by using a combination of data scanning and data cataloging techniques. It also ensures data consistency by maintaining a data catalog that tracks the schema and data lineage. By using AWS Glue, you can build a data pipeline that meets the requirements of the task.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company has a requirement to build a data pipeline that extracts data from a relational database and loads it into a data warehouse. The pipeline should be able to handle incremental data loads and ensure data consistency. Which AWS service would you use to build this pipeline, and why?
A
AWS Glue
B
Amazon Redshift
C
AWS Data Pipeline
D
Amazon Kinesis Data Firehose
No comments yet.