Explanation:
When Athena does not return data from an S3-backed table, common causes include pointing the table to the wrong S3 location or having unmapped partitions. Confirming the correct S3 location (A) ensures the data path is correct. Using the MSCK REPAIR TABLE command (C) updates the Glue Data Catalog with any new partitions (such as those based on year) added to the S3 bucket, allowing Athena to query the newly partitioned data.
Ultimate access to all questions.
Question 57
A company has a data lake in Amazon S3. The company collects AWS CloudTrail logs for multiple applications. The company stores the logs in the data lake, catalogs the logs in AWS Glue, and partitions the logs based on the year. The company uses Amazon Athena to analyze the logs. Recently, customers reported that a query on one of the Athena tables did not return any data. A data engineer must resolve the issue. Which combination of troubleshooting steps should the data engineer take? (Choose two.)
A
Confirm that Athena is pointing to the correct Amazon S3 location.
B
Increase the query timeout duration.
C
Use the MSCK REPAIR TABLE command.
D
Restart Athena.
E
Delete and recreate the problematic Athena table.
No comments yet.