Answer-first summary for fast verification
Answer: AWS Glue workflows
Option B is CORRECT because AWS Glue workflows are designed to orchestrate and manage complex ETL workflows in AWS Glue. They can handle the entire process from crawling the Microsoft SQL Server table to transforming and loading the data into an Amazon S3 bucket. AWS Glue workflows provide a cost-effective, fully managed solution specifically tailored for ETL processes, with minimal additional overhead compared to other options.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 21/60
A company created an extract, transform, and load (ETL) data pipeline in AWS Glue. A data engineer must crawl a table that is in Microsoft SQL Server. The data engineer needs to extract, transform, and load the output of the crawl to an Amazon S3 bucket. The data engineer also must orchestrate the data pipeline.
Which AWS service or feature will meet these requirements MOST cost-effectively?
A
AWS Step Functions
B
AWS Glue workflows
C
AWS Glue Studio
D
Amazon Managed Workflows for Apache Airflow (Amazon MWAA)
No comments yet.