PepsiCo Interview Question
What's the difference between the Star and Snowflake schema? How would you optimize a join in Spark using partitions?
Interview Answer
Anonymous
Sep 4, 2022
I told them that the tech stack I have been using for quite some time - BigQuery i.e. a columnar database didn't require any such normalization, schema design, or optimization. That's all I knew. I found their questions to be quite shallow and microscopic.