Q11 — AWS SAA-C03 Ch.16

Question 11 of 100 | ← Chapter 16

Q1211. 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 needs a data visualization solution that is compatible with Amazon Redshift and Amazon S3.Which solution will meet these requirements?

Correct Answer: A. Use Amazon Redshift query editor v2 to analyze data stored in Amazon Redshift. Use Amazon Athena to analyze data stored in Amazon S3. Use Amazon QuickSight to access Amazon Redshift and Athena,visualize the data analyses,and create business intelligence reports.

Explanation

To meet the company's requirements of analyzing structured data stored in Amazon Redshift and unstructured data stored in Amazon S3, and creating business intelligence reports with a compatible data visualization solution, the most suitable option is:A. Use Amazon Redshift query editor v2 to analyze data stored in Amazon Redshift. Use Amazon Athena to analyze data stored in Amazon S3. Use Amazon QuickSight to access Amazon Redshift and Athena, visualize the data analyses, and create business intelligence reports.Analysis:Amazon Redshift Query Editor v2:Structured Data Analysis: Amazon Redshift query editor v2 provides a web-based interface for running SQL queries against data stored in Amazon Redshift. This allows analysts to easily explore and analyze structured data stored in Redshift.Amazon Athena:Unstructured Data Analysis: Amazon Athena is a serverless interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is ideal for analyzing unstructured data stored in S3, such as log files, JSON documents, and CSV files.Amazon QuickSight:Data Visualization and Reporting: Amazon QuickSight is a fully managed business intelligence (BI) service that makes it easy to create and publish interactive dashboards and reports. QuickSight can connect to both Amazon Redshift and Amazon Athena, allowing you to visualize the data analyses from both sources and create comprehensive business intelligence reports.Why Other Options Are Not Suitable:B. Use Amazon Redshift Serverless and Amazon S3 Object Lambda with Amazon Managed Grafana:Amazon S3 Object Lambda: While S3 Object Lambda allows you to add your own code to S3 GET requests to modify and process data as it is being retrieved, it is not designed for data analysis. Amazon Managed Grafana: Grafana is primarily used for time-series data visualization and monitoring, not for comprehensive business intelligence reporting that integrates with both structured and unstructured data sources like Redshift and S3.C. Use Amazon Redshift Spectrum to analyze data stored in Amazon Redshift:Incorrect Use of Redshift Spectrum: Amazon Redshift Spectrum is actually used to query data directly from Amazon S3 without loading it into Redshift, not for analyzing data stored in Redshift itself. The correct approach for analyzing Redshift data is to use the Redshift query editor v2 or other SQL clients. However, this option is still partially correct in suggesting the use of Athena for S3 data and QuickSight for visualization, but the Redshift Spectrum part is misleading. D. Use Amazon OpenSearch Service with Amazon Managed Grafana:Amazon OpenSearch Service: While OpenSearch (formerly Elasticsearch) is useful for search and analytics, it is not the best choice for analyzing structured data stored in Amazon Redshift and unstructured data stored in Amazon S3 in the context of creating business intelligence reports. Amazon Managed Grafana: As mentioned earlier, Grafana is not the best tool for comprehensive business intelligence reporting that integrates with both Redshift and S3.