Snowflake:
Snowflake architecture
Snowpipe, Stream, Tasks
Data Models
Data Dimensions
Access
Cloud concepts
Azure:
ADF pipeline
Schema drift
Data Bricks
Architecture
Jobs monitoring
Scaling
SQL
Lead, Lag
Window functions
Query execution
Indexes
Performance tuning