ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam
Go to Exam

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 102 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01
Question #: 102
Topic #: 1
[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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.
Show Suggested Answer Hide Answer
Suggested Answer: BE 🗳️
by tgv at June 15, 2024, 11 a.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Ja13
Highly Voted 11 months, 3 weeks ago
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.
upvoted 5 times
...
HagarTheHorrible
Most Recent 5 months, 4 weeks ago
Selected Answer: BE
both are more or less the only possible
upvoted 1 times
...
GHill1982
1 year ago
Selected Answer: 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.
upvoted 2 times
...
tgv
1 year ago
Selected Answer: 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.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel