Q31 — AWS SAA-C03 第3章

第 31/65 题 | ← 返回第3章

Q161.一家公司在 AWS 上托管一个数据湖.数据湖由 Amazon S3 和 Amazon RDS for PostgreSQL 中的数据组成.该公司需要一个报告解决方案来提供数据可视化并包括数据湖中的所有数据源.只有公司的管理团队才能完全访问所有可视化.公司的其他人应该只有有限的访问权限.哪种解决方案可以满足这些要求?

正确答案: B. 在 Amazon QuickSight 中创建分析.连接所有数据源并创建新数据集.发布仪表板以可视化数据.与适当的用户和组共享仪表板.

解析

To meet the requirement of providing a reporting solution that includes all the data sources within the data lake and allows only the management team to have full access, a solutions architect should create an analysis in Amazon QuickSight, connect the data sources, and publish dashboards to visualize the data. The dashboards can then be shared with the appropriate IAM roles or users and groups as required. Therefore, option B is the correct answer.Option A is similar to option B, but it suggests sharing dashboards with specific IAM roles. This could work, but using specific users and groups will provide greater flexibility and easier management.Option C suggests using AWS Glue to produce reports and publishing them to Amazon S3, but it does not provide visualization capabilities or allow for restricting access based on IAM roles.Option D suggests using Amazon Athena Federated Query to generate reports by accessing data in both Amazon S3 and Amazon RDS for PostgreSQL, but it does not provide visualization capabilities or allow for restricting access based on IAM roles.Amazon QuickSight provides robust data visualization capabilities and supports a wide range of data sources, including Amazon S3 and Amazon RDS for PostgreSQL. By using specific users and groups, the solution can ensure that only the management team has full access to the visualizations while limiting access for other users. This approach will provide a secure and flexible solution for reporting and data visualization within the data lake.为了满足提供包含数据湖中所有数据源并且只允许管理团队完全访问的报告解决方案的需求，解决方案架构师应该在Amazon QuickSight中创建分析，连接数据源，并发布仪表板以可视化数据。然后，仪表板可以根据需要与适当的IAM角色或用户和组共享。因此，选项B是正确答案。选项A类似于选项B，但它建议与特定的IAM角色共享仪表板。这是可行的，但是使用特定的用户和组将提供更大的灵活性和更容易的管理。选项C建议使用AWS Glue生成报告并将其发布到Amazon S3，但它不提供可视化功能，也不允许基于IAM角色限制访问。选项D建议使用Amazon Athena Federated Query通过访问Amazon S3和Amazon RDS中的数据为PostgreSQL生成报表，但它不提供可视化功能，也不允许基于IAM角色限制访问。Amazon QuickSight提供了强大的数据可视化功能，并支持广泛的数据源，包括Amazon S3和Amazon RDS for PostgreSQL。通过使用特定的用户和组，解决方案可以确保只有管理团队才能完全访问可视化，同时限制其他用户的访问。这种方法将为数据湖中的报告和数据可视化提供安全而灵活的解决方案。