Free Top Amazon/AWS DEA-C01 Actual Exam Questions - Question 14 Discussion
the data into a central data warehouse to perform analytics. Users need fast response times for
analytics queries.
The company uses Amazon QuickSight in direct query mode to visualize the data. Users normally run
queries during a few hours each day with unpredictable spikes.
Which solution will meet these requirements with the LEAST operational overhead?
What about B? Athena scales automatically and fits unpredictable spikes with no infra management.
A/D? Aurora is more OLTP, not analytics-optimized, so A fits better here.
A/B? A offers speed and scaling, but Athena (B) means zero cluster management.
Maybe B could work since Athena queries data in S3 directly, so no cluster management is needed and it handles variable query loads well. But performance might be slower than Redshift options for complex analytics.
A definitely seems right since Redshift Serverless scales automatically and offers fast query performance. Plus, it handles data consolidation well without the hassle of managing infrastructure.
Maybe B, since Athena queries data directly from S3 without managing clusters, reducing overhead.
I’m leaning towards A. Redshift Serverless fits well for unpredictable spikes since it scales automatically and supports fast queries, plus it has low operational overhead compared to managing provisioned clusters. QuickSight direct query works smoothly with Redshift too. Anyone else think the same?