A marketing firm streams clickstream events to Kinesis Data Firehose and stores them in Amazon S3. They plan to build dashboards in Amazon QuickSight for hundreds of users across departments and need a scalable, cost-effective solution with daily updates. Which combination of steps meets these requirements most economically? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Use Amazon Athena to query the clickstream data, Access the query data through QuickSight SPICE (Super-fast, Parallel, In-memory Calculation Engine). Configure a daily refresh for the dataset..
Why this is the answer
Using Amazon Athena to query clickstream data directly from Amazon S3 is cost-effective because you pay only for the data scanned, and it scales automatically. This avoids the overhead and cost of managing a dedicated data warehouse like Amazon Redshift, which is better suited for complex analytical workloads and large, structured datasets. Amazon S3 analytics is for storage analysis, not querying data. Accessing the queried data through QuickSight SPICE with a daily refresh is optimal. SPICE caches the data, providing fast dashboard performance for hundreds of users without repeatedly querying the underlying data source (Athena), which would increase costs. A direct SQL query from QuickSight to Athena would incur charges for every user interaction, making it less cost-effective and potentially slower for many users.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed