AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A company utilizes AWS Lake Formation to manage an Amazon S3 data lake and seeks to integrate visualizations in Amazon QuickSight by merging data from the data lake with Amazon Aurora MySQL operational data. The company requires column-level access control for the marketing team, restricting access to specific columns. Identify the solution with minimal operational overhead for this requirement.
A
Ingest data from the database directly into QuickSight SPICE, filtering to include only necessary columns using Amazon EMR.
B
Leverage AWS Glue Studio for data ingestion into S3, enforce column-level access via IAM policies for QuickSight users, with S3 serving as the data source in QuickSight.
C
Employ AWS Glue Elastic Views to generate a materialized view in S3 from the database, apply an S3 bucket policy for column-level access control, and utilize S3 as the QuickSight data source.
D
Utilize Lake Formation blueprint for data ingestion into S3 from the database, enforce column-level access control with Lake Formation, and use Amazon Athena as the QuickSight data source.