A company needs to extract data from various databases, transform it, and load it into a data warehouse. They want a fully managed, serverless ETL (Extract, Transform, Load) service that can automatically discover the data schema. Which service should they use?

Answer options:

Amazon EMR

AWS Data Pipeline

AWS Glue

Amazon Athena

How to approach this question

Match 'serverless ETL' and 'schema discovery' to AWS Glue.

Full Answer

C.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 includes Glue Crawlers to automatically infer schemas.

Common mistakes

Choosing EMR, which is powerful for big data but requires managing EC2 clusters.

Question 51 All questions Question 53

Practice the full AWS SAA-C03 Practice Exam 5

65 questions · hints · full answers · grading

More questions from this exam

Q01A company needs to grant an external auditor read-only access to specific AWS resources. The audi...Easy Q02An application running on EC2 instances needs to access objects in an S3 bucket. The security tea...Medium Q03A company is designing a VPC for a multi-tier web application. They need to block specific malici...Medium Q04A large enterprise uses AWS Organizations to manage multiple accounts. The security team wants to...Hard Q05A company hosts a web application on an Application Load Balancer (ALB). They are experiencing SQ...Medium

View all 65 questions →