QuestionQ89

VerifiedData Operations and Support

A company maintains a data lake in Amazon S3. It collects AWS CloudTrail logs for multiple applications, stores those logs in the data lake, catalogs them with AWS Glue, and partitions them by year. The company uses Amazon Athena to analyze the logs.

Recently, customers reported that a query against one Athena table returned no data. A data engineer must resolve the issue.

Which combination of troubleshooting steps should the data engineer perform?

Choose two
Explanation

Athena reads an external table from its configured Amazon S3 location, so the table must point to the S3 prefix that contains the log data. Partitioned data also requires corresponding partition metadata in the AWS Glue Data Catalog. MSCK REPAIR TABLE scans the configured S3 location and adds discovered Hive-compatible partitions to the table metadata, making their data queryable.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!