A reseller that has thousands of AWS accounts receives AWS Cost and Usage Reports in an Amazon S3 bucket The reports are delivered to the S3 bucket in the following format

//yyyymmdd-yyyymmdd/ parquet

An AWS Glue crawler crawls the S3 bucket and populates an AWS Glue Data Catalog with a table Business analysts use Amazon Athena to query the table and create monthly summary reports for the AWS accounts The business analysts are experiencing slow queries because of the accumulation of reports from the last 5 years The business analysts want the operations team to make changes to improve query performance

Which action should the operations team take to meet these requirements?

A. Change the file format to csv.zip.

B Partition the data by date and account ID

C Partition the data by month and account ID

D Partition the data by account ID, year, and month

NOTE : One of my test papers is saying the answer is A, other online test papers are saying B, BUT Chegg consultant is saying D (without any justification which I am not convinced hence ) resubmitting the request once again ............. I need the correct answer with justification. please don't answer if you don't have justification