SAA-C03 Q181 · Analytics

Question

A company uses AWS Lake Formation to govern its S3 data lake. It wants to visualize data in QuickSight by joining S3 data with Aurora MySQL operational data. The marketing team must see only specific columns. Which solution provides column-level authorization with the least operational overhead?

Accepted Answer

Option D satisfies every requirement with minimal operational overhead:

1. **Lake Formation Blueprint for Ingestion**: Lake Formation provides pre-built blueprints specifically designed to ingest data from JDBC sources (like Aurora MySQL) into S3. This is a managed, low-overhead way to move operational database data into the data lake — no custom ETL code required.

2. **Column-Level Access Control via Lake Formation**: Lake Formation natively supports **column-level permissions**. You can grant the marketing team access to only specific columns in the Data Catalog table. This is the core governance feature Lake Formation was built for.

3. **Athena as QuickSight Data Source**: Athena integrates natively with both Lake Formation (inheriting its permissions) and QuickSight. When QuickSight

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips