Question 1

A company receives daily CSV files in an Amazon S3 bucket. They need to automatically transform these files into Apache Parquet format and catalog the metadata so the data can be queried using Amazon Athena. Which AWS service should be used for the transformation and cataloging?

Accepted Answer

Look for 'transform', 'catalog metadata', and 'Athena'. AWS Glue is the serverless ETL and catalog service.

Question 2

What mistakes do candidates make on this AWS SAA-C03 question?

Accepted Answer

Choosing EMR, which is powerful but not the most operationally efficient choice for simple serverless ETL and cataloging.

A company receives daily CSV files in an Amazon S3 bucket. They need to automatically transform these files into Apache Parquet format and catalog the metadata so the data can be queried using Amazon Athena. Which AWS service should be used for the transformation and cataloging?

How to approach this question

Full Answer

Common mistakes

Practice the full AWS SAA-C03 Practice Exam 7

More questions from this exam