amazon · AWS-Certified-Data-Engineer---Associate-DEA-C01 · Q428 · multiple_response · topic_1

A marketing company collects clickstream data. The company sends the clickstream data to Amazon Kinesis Data Firehose a…

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.

Explanation

Selected Answer: BE B. Use Amazon Athena to query the clickstream data. E. Access the query data through QuickSight SPICE (Super-fast, Parallel, In-memory Calculation Engine). Configure a daily refresh for the dataset. Here's why: B. Use Amazon Athena to query the clickstream data: Amazon Athena allows you to run SQL queries directly on data stored in Amazon S3 without the need for complex ETL processes. It is a cost-effective solution for querying large datasets on S3. E. Access the query data through QuickSight SPICE: QuickSight SPICE is designed for fast, in-memory data analysis and can scale to support many users and large datasets. By configuring a daily refresh, you ensure that the dashboards are updated with the latest data while keeping query performance high and costs low.

Reference: examtopics_top_comment

Practice with progress tracking

Start tracked practice Pricing