The Algorithm Game
This algorithm finds shortest paths.
What is Dijkstra's algorithm?
This SQL clause is used to filter groups after aggregation.
What is HAVING?
This algorithm is used for sorting.
What is quicksort?
You notice a data pipeline fails every Monday at 2 AM. Logs show a timeout error from an external API. This is the most likely root cause.
What is a scheduled maintenance or rate limit on the external API?
This algorithm is used in recommendation systems.
What is collaborative filtering?
Your regression model has high accuracy but performs poorly on new data. This is the most likely issue.
What is overfitting?
This algorithm is used for optimization.
What is gradient descent?
You’re asked to explain why customer churn increased last quarter. You start by segmenting users by this type of variable to identify behavioral patterns.
What are categorical variables?
This algorithm is used for searching.
What is binary search?
You’re optimizing a query that joins three large tables. This strategy can significantly reduce execution time.
What is indexing the join keys?