Answer-first summary for fast verification
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.
Using Amazon Athena to query data stored directly in Amazon S3 combined with QuickSight SPICE configured for daily refreshes provides a highly scalable and cost-effective architecture for this scenario. Redshift might be over-provisioning for only daily dashboard updates, and direct SQL queries could be slower and more expensive than utilizing SPICE.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 30
A marketing company collects clickstream data. The company sends the clickstream data to Amazon Kinesis Data Firehose and stores the clickstream data in Amazon S3. The company wants to build a series of dashboards that hundreds of users from multiple departments will use. The company will use Amazon QuickSight to develop the dashboards. The company wants a solution that can scale and provide daily updates about clickstream activity. Which combination of steps will meet these requirements MOST cost-effectively? (Choose two.)
A
Use Amazon Redshift to store and query the clickstream data.
B
Use Amazon Athena to query the clickstream data.
C
Use Amazon S3 analytics to query the clickstream data.
D
Access the query data through a QuickSight direct SQL query.
E
Access the query data through QuickSight SPICE (Super-fast, Parallel, In-memory Calculation Engine). Configure a daily refresh for the dataset.
No comments yet.