DAS-C01 Question #149: Real Exam Question with Answer & Explanation

Question

A marketing company collects clickstream data. The company sends the data to Amazon Kinesis Data Firehose and stores the data in Amazon S3. The company wants to build a series of dashboards that will be used by hundreds of users across different departments. The company will use Amazon QuickSight to develop these dashboards. The company has limited resources and wants a solution that could scale and provide daily updates about clickstream activity. Which combination of options will provide the MOST cost-effective solution? (Select TWO )

Options

• AUse Amazon Redshift to store and query the clickstream data
• BUse QuickSight with a direct SQL query
• CUse Amazon Athena to query the clickstream data in Amazon S3
• DUse S3 analytics to query the clickstream data
• EUse the QuickSight SPICE engine with a daily refresh

Explanation

For building scalable and cost-effective dashboards with daily updates on large clickstream data in Amazon S3 for hundreds of users, a combination of defining data via SQL and leveraging QuickSight's in-memory engine is optimal.

Common mistakes.

• A. Storing and querying raw clickstream data directly in Amazon Redshift for daily updates and hundreds of users can be very expensive in terms of storage, compute, and ETL processes, especially when a serverless, pay-per-query model for S3 data exists.
• C. Amazon Athena is a cost-effective, serverless option for querying S3 data. However, for dashboards accessed by hundreds of users, consistently direct querying Athena for every interaction can accumulate high query costs due to the pay-per-query model based on data scanned. It is often more efficient as a source for SPICE.
• E. Amazon S3 Analytics is a storage class analysis tool for optimizing S3 storage costs by identifying access patterns, not a service used for querying data to build interactive dashboards.

Concept tested. QuickSight data sources, SPICE engine, and cost-effective analytics on S3

Reference. https://docs.aws.amazon.com/quicksight/latest/user/working-with-data-sets.html

No community discussion yet for this question.