12 practice questions for Databricks Data Analyst interviews
Databricks data analyst interviews focus on SQL, data visualisation, business metrics, statistical analysis, and translating data insights into actionable recommendations.
Category: Grid/matrix coding problemYou are given a 2D grid representing a city map. Each cell contains one of the following: - 'S' -- your starting location - 'D' -- your...Input: 2D grid Output: Computed result
codingHardVerified Question#2
2. IP CIDR Firewall
Category: String coding problemAn IP address is a 32-bit number written as four decimal octets separated by dots, such as 10.0.0.1. A CIDR block is written as base_ip/k, which...Input: List Output: Computed result
codingMediumVerified Question#3
3. Bottleneck Dependencies
Category: Graph coding problemYou are managing a build pipeline for a software project. The pipeline contains n components labeled 0 to n-1, connected by prerequisite...Input: Graph (nodes and edges) Output: Computed result
codingHardVerified Question#4
4. Circuit Breaker
Category: Array coding problemIn a distributed system, a circuit breaker mechanism shields backend servers from cascading failures. When a server encounters a streak of...Input: Array Output: Computed result
codingMediumVerified Question#5
5. Encode And Decode
Category: Array coding problemImplement an encoder and decoder for integer arrays using two compression techniques: Run-Length Encoding (RLE) and Bit Packing (BP).Input: Array of integers Output: Computed result
codingMediumVerified Question#6
6. Customer Revenue System
Category: Algorithm coding problemDesign a customer revenue tracking system that supports direct sign-ups and referral-based registration. Each customer has a unique auto-incrementing...Input: List Output: Array
codingMediumVerified Question#7
7. Design Lazy Array
Category: Array coding problemGiven an integer array, a list of multipliers, and a target value, determine the first index in the array whose element equals the target after all...Input: Array Output: Computed result
codingHardVerified Question#8
8. Find Path in Fibonacci Tree
Category: Binary tree coding problemA Fibonacci tree of order n is a binary tree defined as follows: - A tree of order 0 is a single node. - A tree of order 1 is a single node.Input: Binary tree Output: Computed result
codingHardVerified Question#9
9. Snapshot Set Iterator
Category: Algorithm coding problemDesign a data structure called SnapshotSet that supports adding and removing integers, membership checks, and capturing immutable snapshots of the...Input: List Output: Computed result
codingMediumVerified Question#10
10. Remove Covered Point
Category: Interval-based coding problemA warehouse uses a shelving system where each shelf occupies a contiguous range of slot positions [start, end) (the end position is exclusive --...Input: List Output: Computed result
codingMediumVerified Question#11
11. Tic-Tac-Toe II
Category: Algorithm coding problemDesign a generalized Tic-Tac-Toe game played on an n x m board where the first player to place k consecutive marks in a row, column, or diagonal...Input: Number(s) Output: Computed result