A company stores CloudTrail logs in an S3 data lake, catalogs them in AWS Glue, and partitions them by year. An Athena query on one of the tables recently returned no rows. Which troubleshooting steps should the data engineer take? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Confirm that Athena is pointing to the correct Amazon S3 location., Use the MSCK REPAIR TABLE command..
Why this is the answer
When an Athena query returns no rows unexpectedly, a common cause is a mismatch between the table definition and the actual data location. Confirming that Athena is pointing to the correct Amazon S3 location for the table is crucial, as an incorrect path would lead to no data being found. Additionally, if new partitions (e.g., for a new year) have been added to the S3 data lake but not registered with the AWS Glue Data Catalog, Athena won't recognize them. The MSCK REPAIR TABLE command scans the S3 location defined for the table and updates the Glue Data Catalog with any new partitions it discovers, making them queryable by Athena. Increasing the query timeout duration is unlikely to help if no rows are returned, as it addresses long-running queries, not missing data. Restarting Athena is not a standard troubleshooting step for this issue. Deleting and recreating the table is an extreme measure that should only be considered after simpler troubleshooting steps have failed.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed