A company hosts a data lake on AWS containing data in Amazon S3 and Amazon RDS for PostgreSQL. The company needs a reporting solution that visualizes all data sources. Only management should have full access to all visualizations; the rest of the company should have limited access. Which solution meets these requirements?
Choose an answer
Tap an option to check your answer.
Correct answer: Create an analysis in Amazon QuickSight. Connect all data sources and create datasets. Publish dashboards to visualize the data and share the dashboards with the appropriate users and groups..
Why this is the answer
The correct solution is to use Amazon QuickSight. QuickSight is a business intelligence service designed for creating interactive dashboards and visualizations. It can connect to various data sources, including Amazon S3 and Amazon RDS for PostgreSQL, allowing for a unified reporting solution. Sharing dashboards with specific users and groups within QuickSight provides granular control over access, fulfilling the requirement for different access levels for management and other employees. The first incorrect option is wrong because while IAM roles can be used for QuickSight permissions, sharing dashboards directly with QuickSight users and groups is the more common and direct method for managing access within QuickSight itself. The third and fourth incorrect options, involving AWS Glue and Amazon S3 bucket policies, are less suitable because they focus on data processing and storage rather than direct visualization and interactive reporting. While they can prepare data, they don't inherently provide a visualization layer with user-level access control for dashboards like QuickSight does.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed