AWS Certified Data Engineer – Associate (DEA-C01) — Question 147
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.)
Answer options
- 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.
Correct answer: A, C
Explanation
Option A is correct because confirming Athena's S3 location ensures the query accesses the right data. Option C is also correct, as the MSCK REPAIR TABLE command updates the metadata in the Athena table to include any new partitions. The other options do not directly address the issue of missing data from the query.