Which solution will meet these requirements?
Create an analysis in Amazon QuickSight. Connect all the data sources and create new datasets. Publish dashboards to visualize the data. Share the dashboards with the appropriate IAM roles.
Create an analysis in Amazon QuickSight. Connect all the data sources and create new datasets. Publish dashboards to visualize the data. Share the dashboards with the appropriate users and groups.
Create an AWS Glue table and crawler for the data in Amazon S3. Create an AWS Glue extract, transform, and load (ETL) job to produce reports. Publish the reports to Amazon S3. Use S3 bucket policies to limit access to the reports.
Create an AWS Glue table and crawler for the data in Amazon S3. Use Amazon Athena Federated Query to access data within Amazon RDS for PostgreSQL. Generate reports by using Amazon Athena. Publish the reports to Amazon S3. Use S3 bucket policies to limit access to the reports.
Explanations:
While Amazon QuickSight can create analyses and share dashboards, the sharing must be done with specific users and groups to manage access effectively. Simply sharing with IAM roles may not provide the necessary granularity for limiting access to the management team only.
Amazon QuickSight allows for creating analyses from multiple data sources, including Amazon S3 and Amazon RDS. By sharing the dashboards with specific users and groups, it can restrict access appropriately, ensuring the management team has full access while limiting others.
AWS Glue is used for data cataloging and ETL, but this solution does not directly provide data visualization. Publishing reports to S3 with bucket policies limits access, but it lacks a robust reporting and visualization component compared to QuickSight.
Although this option includes using AWS Glue and Amazon Athena for querying data across sources, it also lacks a direct reporting and visualization solution. It publishes reports to S3, but similar to option C, it does not facilitate access control for visualizations in a way that meets the management team’s needs.
I rank that the answer is:
Create an analysis in Amazon QuickSight. Connect all the data sources and create new datasets. Publish dashboards to visualize the data. Share the dashboards with the appropriate users and groups.