A retail company wishes to perform exploratory analysis on user interaction logs that are aggregated consistently throughout the day. The data, while structured and collected in real-time, demands the flexibility of immediate query capabilities with a syntax similar to SQL. Considering the need for effortless scalability and zero administration, which service would be the optimal choice?
Business intelligence service
Managed data lake solution
Amazon Athena
Managed Hadoop framework