Correct Answer: Convert the data to a columnar format like Parquet or ORC and partition it by date
Columnar formats like Parquet allow Athena to only read the specific columns required for a query. Partitioning allows it to skip entire folders of data that don't match the query ...
Correct Answer
Convert the data to a columnar format like Parquet or ORC and partition it by date
Why This Answer Is Correct
Columnar formats like Parquet allow Athena to only read the specific columns required for a query. Partitioning allows it to skip entire folders of data that don't match the query criteria.
This question evaluates your knowledge of Amazon S3 — a core concept tested in AWS Certified Solutions Architect – Professional (SAP-C02). Understanding Amazon S3 is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
You need to host a static website (HTML, CSS, JS) with the lowest possible cost and high durability. You do not need server-side processing. Which storage solution should you choose?
You need to grant developers read-only access to Amazon S3 buckets without giving them access to other services. What's the best approach using AWS IAM?
An organization is migrating a 2 PB data archive from an on-premises Hadoop cluster to Amazon S3. They have a 1 Gbps internet connection and a 100 Mbps direct link. Bandwidth is limited and they need the migration to finish within 4 weeks. What is the most feasible way to migrate ?
A fintech startup wants to ensure that no developer can accidentally grant public access to S3 buckets containing sensitive customer data. They want an automated way to detect AND automatically remediate this at the organization level. How should they implement this?
Your application uses Amazon S3 to store millions of small objects. You find that the costs for 'GET' and 'PUT' requests are higher than the storage costs. What is the most effective way to reduce the overall request costs for these small objects?