Athena Queries Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Data Automation

What you'll be asked

  1. Which AWS service does Amazon Athena primarily use to store the underlying data that you query?
  2. When querying data in Athena, why is it recommended to use columnar formats like Apache Parquet or ORC?
  3. You have a large dataset in S3 partitioned by 'year', 'month', and 'day'. Which query structure will be the most cost-effective?
  4. What is the primary purpose of an AWS Glue Data Catalog in the context of Amazon Athena?
  5. You are encountering an 'HIVE_BAD_DATA' error when querying a CSV file in Athena. What is the most likely cause?

Answers and explanations come after you submit.