DAS-C01 · Question #16
A marketing company wants to improve its reporting and business intelligence capabilities. During the planning phase, the company interviewed the relevant stakeholders and discovered that: - The…
The correct answer is B. Store the last 2 months of data in Amazon Redshift and the rest of the months in Amazon S3. Storing the last 2 months of data in Amazon Redshift and the remainder in Amazon S3 is the most cost-effective solution. Redshift covers the operations team (current month, hourly) and the sales team (last 30 days). The finance team's daily last-month reports are covered by the…
Question
A marketing company wants to improve its reporting and business intelligence capabilities. During the planning phase, the company interviewed the relevant stakeholders and discovered that:
- The operations team reports are run hourly for the current month's
data.
- The sales team wants to use multiple Amazon QuickSight dashboards to
show a rolling view of the last 30 days based on several categories. The sales team also wants to view the data as soon as it reaches the reporting backend.
- The finance team's reports are run daily for last month's data and
once a month for the last 24 months of data. Currently, there is 400 TB of data in the system with an expected additional 100 TB added every month. The company is looking for a solution that is as cost-effective as possible. Which solution meets the company's requirements?
Options
- AStore the last 24 months of data in Amazon Redshift.
- BStore the last 2 months of data in Amazon Redshift and the rest of the months in Amazon S3.
- CStore the last 24 months of data in Amazon S3 and query it using Amazon Redshift Spectrum.
- DStore the last 2 months of data in Amazon Redshift and the rest of the months in Amazon S3.
How the community answered
(33 responses)- A6% (2)
- B73% (24)
- C15% (5)
- D6% (2)
Explanation
Storing the last 2 months of data in Amazon Redshift and the remainder in Amazon S3 is the most cost-effective solution. Redshift covers the operations team (current month, hourly) and the sales team (last 30 days). The finance team's daily last-month reports are covered by the 2-month Redshift window, while the 24-month historical reports can query S3 via Amazon Redshift Spectrum or Athena at much lower cost. Storing 24 months in Redshift would be far more expensive given 400 TB of existing data plus 100 TB/month growth. Keeping only 2 months in Redshift minimizes cost while meeting all access patterns.
Topics
Community Discussion
No community discussion yet for this question.