AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 189

Question

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.)

Accepted Answer

Correct answer: A, C. The correct answer is A, C. Option A: Confirm that Athena is pointing to the correct Amazon S3 location. Option C: Use the MSCK REPAIR TABLE command. Amazon S3 provides durable, scalable object storage that is fully managed. Amazon Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage.

AWS Certified Data Engineer - Associate DEA-C01 — Question 189