Athena SQL Analysis Quiz

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

Quiz covering Data Analysis

What you'll be asked

  1. Which SQL clause is used in Amazon Athena to filter rows based on a specific condition after the data has been retrieved from the table?
  2. When querying data in Athena stored in Amazon S3, why is it recommended to use partitioned columns in your WHERE clause?
  3. You have a large table and need to find the top 5 customers by total purchase amount. Which combination of clauses should you use?
  4. If you need to join a large fact table with a small reference table in Athena, which optimization technique helps improve query performance?
  5. You are querying data stored in Parquet format. You notice that even with a partition filter, the query scans more data than expected. What is the most likely cause?

Answers and explanations come after you submit.