This is a dedicated watch page for a single video.
A data engineer is encountering slow query performance while executing Amazon Athena queries on datasets stored in an Amazon S3 bucket, with AWS Glue Data Catalog serving as the metadata repository. The data engineer has identified the root cause of the sluggish performance as the excessive number of partitions in the S3 bucket, leading to increased Athena query planning times. What are the two possible approaches to mitigate this issue and enhance query efficiency (Select two)?