A company uses Amazon Redshift to store structured data and Amazon S3 to store unstructured data. The company wants to analyze the stored data and create business intelligence reports. The company nee

Question

Options

• AUse Amazon Redshift query editor v2 to analyze data stored in Amazon Redshift. Use Amazon
• BUse Amazon Redshift Serverless to analyze data stored in Amazon Redshift. Use Amazon S3
• CUse Amazon Redshift Spectrum to analyze data stored in Amazon Redshift. Use Amazon Athena
• DUse Amazon OpenSearch Service to analyze data stored in Amazon Redshift and Amazon S3.

• A
  6% (2)
• B
  16% (5)
• C
  74% (23)
• D
  3% (1)

Explanation

This solution leverages: Amazon Redshift Spectrum to query S3 data directly from Redshift. Amazon Athena for ad-hoc analysis of S3 data. Amazon QuickSight for unified visualization from multiple data sources. "Redshift Spectrum enables you to run queries against exabytes of data in Amazon S3 without having to load or transform the data." "QuickSight supports both Amazon Redshift and Amazon Athena as data sources." This architecture allows scalable querying and visualization with minimum ETL overhead, ideal for BI dashboards. Incorrect Options: A: The query editor is not a BI tool. B, D: Grafana is better for time-series data, not structured analytics or BI reports.

No community discussion yet for this question.