A company has decided to start using AWS Athena for querying data in S3. The amount of data is huge and they need to create queries based on a subset of data. How can they accomplish this in the easiest manner?

Answer options:

A.Split the files in S3
B.Use views in Athena
C.Create different buckets in S3
D.Create different types of charts in Athena

Answer B
The AWS Documentation mentions the following
You may want to create views to:
Query a subset of data. For example, you can create a table with a subset of columns from the original table to simplify querying data.
Combine multiple tables in one query. When you have multiple tables and want to combine them with UNION ALL, you can create a view with that expression to simplify queries against the combined tables.
Options A and C are incorrect since this would cause a maintenance overhead
Option D is incorrect since here we need to optimize the query and not the visualization
For more information on when to use views, please refer to the below URL
https://docs.aws.amazon.com/athena/latest/ug/when-to-use-views.html