Role track
AI Engineer
RAG as ETL, feature tables without leakage, and Cortex as a transform.
155 questions · SQL · Python · RAG / features · Streaming · System design
Suggested sequence
1. Retrieval is a pipeline
Chunk, embed, version, ACL-filter. The model brand is not the incident.
AI / RAG questions →2. Coding for eval
Ranking, entropy, JSON payloads — retrieval is a join.
AI coding →3. The flowchart
Index refresh as a job. Eval as a job. Rollback as a job.
AI roadmap →4. Serving and SLAs
When the warehouse is the wrong online path.
System design →
Stacks in this loop
Sample questions
medium · Warehouse · Capital One
A Medium warehouse is slower but cheaper than Large. When is that true?
Practice →medium · Warehouse · Snowflake
Someone DELETED gold.orders. What do you do in the first ten minutes?
Practice →medium · Warehouse · McKinsey
Result cache vs warehouse cache vs metadata cache — which one did this dashboard hit?
Practice →medium · Warehouse · Palantir
Would you put Cortex COMPLETE inside a Looker explore?
Practice →medium · Warehouse · Netflix
Micro-partitions and clustering: when does a clustering key pay for itself?
Practice →medium · Warehouse · Airbnb
Streams and Tasks vs an external orchestrator. How do you choose?
Practice →