nerdexam
AmazonAmazon

DEA-C01 · Question #112

DEA-C01 Question #112: Real Exam Question with Answer & Explanation

The correct answer is B: Use Amazon Athena to query the clickstream data. 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.

Data Store Management

Question

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

Options

  • AUse Amazon Redshift to store and query the clickstream data.
  • BUse Amazon Athena to query the clickstream data
  • CUse Amazon S3 analytics to query the clickstream data.
  • DAccess the query data through a QuickSight direct SQL query.
  • EAccess the query data through QuickSight SPICE (Super-fast, Parallel, In-memory Calculation

Explanation

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.

Topics

#Amazon Athena#Amazon QuickSight#Serverless Analytics#Cost Optimization

Community Discussion

No community discussion yet for this question.

Full DEA-C01 PracticeBrowse All DEA-C01 Questions