Topic 1 Question 6
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?
AWS Step Functions
AWS Glue workflows
AWS Glue Studio
Amazon Managed Workflows for Apache Airflow (Amazon MWAA)
ユーザの投票
コメント(6)
- 正解だと思う選択肢: B
Glue workflows are the easiest solution here:
👍 9milofficial2024/01/18 - 正解だと思う選択肢: B
I asked an AI. Analysis of the answers: A. AWS Step Functions: It is a good option for orchestrating workflows with steps from different AWS services, but requires additional development to connect to Microsoft SQL Server. B. AWS Glue Workflows: This is the best and most profitable option. AWS Glue is designed specifically for ETL on AWS and integrates directly with data sources such as Microsoft SQL Server through connectors. This allows for easier configuration and avoids the need for additional development. C. AWS Glue Studio: It is a visual interface for AWS Glue that makes it easy to create and manage ETL jobs. However, the underlying functionality comes from AWS Glue (B) workflows. D. Amazon Managed Workflows for Apache Airflow (Amazon MWAA): It's a viable option, but it's generally more expensive than native AWS services like AWS Glue Workflows. Additionally, it requires some Airflow experience for setup and maintenance.
👍 7dev_vicente2024/09/23 - 正解だと思う選択肢: B
Agree with B. CRAWLING and ETL are the main functions of a Glue workflow and MS SQL is supported: https://docs.aws.amazon.com/glue/latest/dg/crawler-data-stores.html
👍 3DevoteamAnalytix2024/05/03
シャッフルモード