AWS Certified Data Analytics Specialty 2021 – Hands-On - Athena Performance
Interactive Video
•
Information Technology (IT), Architecture, Social Studies
•
University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
The video tutorial focuses on optimizing Athena's performance by using columnar data formats like ORC or Parquet, organizing data into a small number of large files, and leveraging partitions. It explains how to preprocess data using tools like Glue and ETL transforms, and how to add partitions to existing datasets using the MSCK REPAIR TABLE command. These strategies help improve query performance and efficiency when working with Athena.
Read more
2 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • 1 pt
What is the impact of using a small number of large files compared to a large number of small files in Athena?
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
3 mins • 1 pt
What command can be used in Athena to add metadata for partitions to an existing database?
Evaluate responses using AI:
OFF
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
