ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam
Go to Exam

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 6 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01
Question #: 6
Topic #: 1
[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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)
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by milofficial at Jan. 18, 2024, 9:32 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
milofficial
Highly Voted 1 year, 5 months ago
Selected Answer: B
Glue workflows are the easiest solution here: https://aws.amazon.com/blogs/big-data/orchestrate-an-etl-pipeline-using-aws-glue-workflows-triggers-and-crawlers-with-custom-classifiers/ https://aws.amazon.com/blogs/big-data/extracting-multidimensional-data-from-microsoft-sql-server-analysis-services-using-aws-glue/
upvoted 9 times
...
dev_vicente
Highly Voted 8 months, 4 weeks ago
Selected Answer: 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.
upvoted 8 times
...
Adrifersilva
Most Recent 8 months, 3 weeks ago
Selected Answer: B
https://community.aws/content/2iBQiAGS4RvEolgSQKu4iF8InTV/choose-the-right-data-orchestration-service-for-your-data-pipeline?lang=en
upvoted 1 times
...
Shubham1989
8 months, 3 weeks ago
Selected Answer: B
Glue is easiest here to choose from.
upvoted 1 times
...
DevoteamAnalytix
1 year, 1 month ago
Selected Answer: 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
upvoted 3 times
...
Alcee
1 year, 3 months ago
Is B !
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel