AWS Certified Solutions Architect - Associate SAA-C03 — Topic 1 Question 341

Question

A company has an Amazon S3 data lake that is governed by AWS Lake Formation. The company wants to create a visualization in Amazon QuickSight by joining the data in the data lake with operational data that is stored in an Amazon Aurora MySQL database. The company wants to enforce column-level authorization so that the company’s marketing team can access only a subset of columns in the database. Which solution will meet these requirements with the LEAST operational overhead?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Use a Lake Formation blueprint to ingest the data from the database to the S3 data lake. Use Lake Formation to enforce column-level access control for the QuickSight users. Use Amazon Athena as the data source in Quic... Amazon S3 provides durable, scalable object storage that is fully managed. Amazon Athena runs serverless SQL queries directly on data in Amazon S3 with no infrastructure to manage. Amazon QuickSight is a serverless business-intelligence and dashboard service.

AWS Certified Solutions Architect - Associate SAA-C03 — Question 341