AWS · SAA-C03
Data lakes, transformation, and analytics
SAA-C03 · Lesson 18 of 23 · 2:33:28
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the SAA-C03 exam (AWS Certified Solutions Architect – Associate). In this lesson: building and securing a data lake with S3 and Lake Formation, transforming data with AWS Glue crawlers and ETL jobs, querying the lake with Athena, Redshift, and Redshift Spectrum, compute for data processing with EMR, and visualization with Quick Sight. Includes three original practice questions.
Preview the topics
- Daily CSV exports make Athena queries slow and expensive, because every query reads every column of every file. What should the architect change first?
- Support staff must see customer names in the complaints table, while analysts query the same table without the name and phone columns, through Athena and Redshift Spectrum. What should the architect use?
- Regional managers want an interactive dashboard of late deliveries, refreshed daily from Athena, and each manager must see only their own region. What should the architect use?