A data engineering team needs to extract data from an Amazon RDS database, transform the data by joining it with reference files in Amazon S3, and load the transformed data into Amazon Redshift. They want a fully managed, serverless ETL (Extract, Transform, Load) service.<br/><br/>Which AWS service should they use?

Answer options:

Amazon EMR

AWS Glue

AWS Data Pipeline

Amazon Athena

How to approach this question

Identify the primary serverless ETL service in AWS.

Full Answer

B.AWS Glue✓ Correct

AWS Glue is a serverless data integration service that makes it easy to discover, prepare, and combine data for analytics, machine learning, and application development. It provides all the capabilities needed for data integration (ETL).

Common mistakes

Choosing EMR, which typically involves managing clusters and is more complex than Glue for standard ETL.

Question 52 All questions Question 54

Practice the full AWS SAA-C03 Practice Exam 6

65 questions · hints · full answers · grading

More questions from this exam

Q01A company has multiple AWS accounts in an AWS Organizations organization. The security team wants...Medium Q02A company has two AWS accounts: Account A for development and Account B for production. Developer...Medium Q03A mobile application needs to authenticate users using their social media accounts (Facebook, Goo...Easy Q04A company is running an application on Amazon EC2 instances. The application needs to connect to ...Medium Q05A company has 50 AWS accounts managed by AWS Organizations. The IT team wants to implement a cent...Easy

View all 65 questions →