AWS Certified Data Engineer Associate · Free Practice Question Medium
Question 13
- A AWS Data Pipeline
- B Amazon Redshift Stored Procedures
- C AWS Glue ETL
- D Amazon Redshift Spectrum
Reveal correct answer
Correct answer: C
Explanation
AWS Glue ETL service is specifically designed for preparing and transforming data for analytics. It provides a serverless environment that can easily integrate data from multiple sources, transform it according to business rules, and then load it into Amazon Redshift for analysis, making it the ideal choice for this scenario.A. AWS Data Pipeline is a web service for orchestrating and automating the movement and transformation of data. While it can be used for data movement, it is not specifically designed for data transformation tasks like AWS Glue ETL.
B. Amazon Redshift Stored Procedures are used for executing SQL queries and logic within Redshift itself. While they can be used for some data transformation tasks, they are not as robust or flexible as AWS Glue ETL for handling complex data transformations before loading into Redshift.
C. AWS Glue ETL is a fully managed extract, transform, and load (ETL) service that makes it easy to prepare and load data for analytics. It is specifically designed for handling data transformation tasks before loading data into Amazon Redshift, making it the correct choice for this scenario.
D. Amazon Redshift Spectrum is a feature that allows querying and analyzing data directly from S3 without the need to load it into Redshift. It is not specifically designed for data transformation before loading data into Redshift.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
