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 visualizations and share dashboards, the requirement specifies that the management team should have full access, while the rest of the company should have limited access. This option does not explicitly address the need for different access levels beyond IAM roles.
This option allows the creation of an analysis in Amazon QuickSight with the ability to share dashboards with specific users and groups. This meets the requirement of having the management team with full access and providing limited access to others within the company.
This solution focuses on AWS Glue and S3 for reporting, but it does not provide a data visualization tool. It lacks the ability to meet the requirement of visualizing data across multiple sources.
Although this option uses AWS Glue and Athena for querying data, it primarily focuses on generating reports rather than data visualization. Additionally, it does not explicitly address the requirement for differentiated access levels for the management team and other employees.