Topic 1 Question 102

AWS Certified Data Engineer - Associate

Topic 1 Question 102
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?

2 つ選択
- Use Amazon Redshift to store and query the clickstream data.
- Use Amazon Athena to query the clickstream data
- Use Amazon S3 analytics to query the clickstream data.
- Access the query data through a QuickSight direct SQL query.
- Access the query data through QuickSight SPICE (Super-fast, Parallel, In-memory Calculation Engine). Configure a daily refresh for the dataset.
ユーザの投票
コメント(4)
- 正解だと思う選択肢: 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.
  
  👍 4
  Ja132024/07/03
- 正解だと思う選択肢: BE
  Agree with B & E. Athena would be cheaper than Redshift. S3 analytics is irrelevant. The functionality in SPICE should be more cost effective than direct SQL by reducing the frequency and volume of queries.
  
  👍 2
  GHill19822024/06/15
- 正解だと思う選択肢: BE
  Athena charges based on the amount of data scanned per query, which can be cost-effective for ad-hoc querying and periodic updates.
  
  SPICE can be more cost-effective for frequent access and analysis by multiple users as it reduces the load on the underlying data source.
  
  👍 1
  tgv2024/06/15
シャッフルモード

ユーザの投票

コメント(4)