AWS Certified Data Engineer – Associate (DEA-C01) — Question 251

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.)

Answer options

• 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.

Correct answer: B, E

Explanation

Using Amazon Athena to query the clickstream data (Option B) is cost-effective as it allows for serverless querying without the need for provisioning any infrastructure. Additionally, utilizing QuickSight SPICE (Option E) enables fast data retrieval and visualization while providing the option for daily data refreshes, which meets the requirement for regular updates. The other options either involve unnecessary costs or do not align with the requirements provided.