https://docs.aws.amazon.com/quicksight/latest/user/sharing-a-dashboard.html

Keywords: - Data lake on AWS. - Consists of data in Amazon S3 and Amazon RDS for PostgreSQL. - The company needs a reporting solution that provides data VISUALIZATION and includes ALL the data sources within the data lake. A - Incorrect: Amazon QuickSight only support users(standard version) and groups (enterprise version). users and groups only exists without QuickSight. QuickSight don't support IAM. We use users and groups to view the QuickSight dashboard B - Correct: as explained in answer A and QuickSight is used to created dashboard from S3, RDS, Redshift, Aurora, Athena, OpenSearch, Timestream C - Incorrect: This way don't support visulization and don't mention how to process RDS data D - Incorrect: This way don't support visulization and don't mention how to combine data RDS and S3

Amazon QuickSight is a fast, cloud-powered business intelligence (BI) service that focuses on data visualization and reporting. It allows users to connect various data sources, create interactive dashboards, and share those dashboards with others.

Amazon QuickSight can connect to various data sources within a data lake.

CD: AWS Glue is ETL so not required here A: Doable but IAM roles is not provided for each user so this cannot be implemented B: Correct, QuickSight can be used for visualisation reports from S3 and RDS . Comapny's management team sounds like an appropriate role for distribution.

Answer- B

I will go with B after watching the video on this link

Going with D only because it mentions S3 permissions A and B do not.

the correct answer is d: the headers of questions A and B are wrong! "Create an analysis in Amazon QuickSight." quickSight does NOT create analyses, it is a dashboard that displays data via graphs

QuickSight suports users (standard) and groups (Enterprise), no support for IAM. Other keywords: VISUALIZATION

https://docs.aws.amazon.com/quicksight/latest/user/sharing-a-dashboard.html

Explanation: Option B involves using Amazon QuickSight, which is a business intelligence tool provided by AWS for data visualization and reporting. With this option, you can connect all the data sources within the data lake, including Amazon S3 and Amazon RDS for PostgreSQL. You can create datasets within QuickSight that pull data from these sources. The solution allows you to publish dashboards in Amazon QuickSight, which will provide the required data visualization capabilities. To control access, you can use appropriate IAM (Identity and Access Management) roles, assigning full access only to the company's management team and limiting access for the rest of the company. You can share the dashboards selectively with the users and groups that need access.

quicksight can share to all users, group email and a specific email with remaining access glue has limited access so this cannot be a way to share to all users.

My opinion is divided here, and I will explain: Option C can be correct because glue crawler is used to access S3, and athena federated query is used to access RDS. My problem with answer C is that it says: "Generate Reports by using athena" And I think that is not true. athena alone does not generate reports, it has to integrate with services such as quickSight and then it generates reports, therefore the answer is not written properly and I think C is a mistake. Since C is wrong I think B is the correct answer.

For anyone wondering how to know what answers to pick when the voted answer and "official" answer are different: Ask ChatGPT the question without giving it the answer choices. This will give you an idea of what the best answer is and a thorough explanation to help your learning

Hey, I made a video to quickly teach you what AWS Glue is https://youtube.com/shorts/ECynBsEaWKo?feature=share

Option D does involve useful components like AWS Glue and Amazon Athena, which can be great for data processing and querying. However, given the emphasis on data visualization, limited access, and user-friendliness, option B (Amazon QuickSight) still seems more suitable for this particular scenario.