A university has tie-ups with local hospitals to aws video
data-engineer video for a university has tie-ups with local hospitals to share anonymized health statistics of people. The data is stored in Amazon S3 as .csv
Answer
Full Certification Question
A university has tie-ups with local hospitals to share anonymized health statistics of people. The data is stored in Amazon S3 as .csv files. Amazon Athena is used to run extensive analytics on the data for finding correlations between different parameters in the data. The university is facing high costs and performance-related issues as the volume of data is growing rapidly. The data in the S3 bucket is already partitioned by date and the university does not want to change this partition scheme. As a data engineer, how can you further improve query performance? (Select two)