A marketing company wants to improve its reporting and business intelligence capabilities. During theplanning 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 last30 days based on several categories. The sales team also wants to view the data as soon as it reachesthe reporting backend.・ The finance team’s reports are run daily for last month’s data and once a month for the last 24 monthsof 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?
A、
Storethelast24monthsofdatainAmazonRedshift.ConfigureAmazonQuickSightwithAmazonRedshiftasthedatasource.
B、
Storethelast2monthsofdatainAmazonRedshiftandtherestofthemonthsinAmazonS3.SetupanexternalschemaandtableforAmazonRedshiftSpectrum.ConfigureAmazonQuickSightwithAmazonRedshiftasthedatasource.
C、
Storethelast24monthsofdatainAmazonS3andqueryitusingAmazonRedshiftSpectrum.ConfigureAmazonQuickSightwithAmazonRedshiftSpectrumasthedatasource.
D、
Storethelast2monthsofdatainAmazonRedshiftandtherestofthemonthsinAmazonS3.Usealong-runningAmazonEMRwithApacheSparkclustertoquerythedataasneeded.ConfigureAmazonQuickSightwithAmazonEMRasthedatasource.
发布时间:2024-09-06 14:43:31