A market research firm collects extensive survey aws video
data-engineer video for a market research firm collects extensive survey data in .csv format, stored with numerous columns. The data analysts primarily focus on
Answer
Full Certification Question
A market research firm collects extensive survey data in .csv format, stored with numerous columns. The data analysts primarily focus on a subset of columns for most of their queries. The firm needs an efficient way to ingest this data into their Amazon S3 data lake to facilitate cost-effective querying with Amazon Athena, especially given that full file scans are rare. Which method should the data engineer use to ingest the survey data into the S3 data lake to optimize for Athena querying and cost efficiency?