Coinbase Interview Questions (11+ Questions)

Implement automated log rotation in Linux using logrotate to prevent disk space exhaustion. Learn how to identify oversized log files exceeding size limits, create logrotate configuration files with daily rotation policies, compress archived logs, retain multiple versions for troubleshooting, and implement postrotate scripts to reload application services. This guide covers assessing current log file sizes, configuring retention policies, testing logrotate functionality, and preventing disk-full incidents. Essential for maintaining system stability, preventing production outages from disk space issues, and implementing sustainable log management strategies.

Troubleshoot pods stuck in Init state by fixing initContainer configuration, resolving executable not found errors, and ensuring proper init sequence completion. Fix startup dependencies, verify command paths, and transition pods from Init to Running state. Essential for pod initialization workflows, dependency setup, data preparation, and multi-stage pod startup sequences.

Optimize GitHub Actions with path filters: trigger workflows only for specific file changes, reduce CI/CD costs, and improve pipeline efficiency dramatically.

def valid_tree(n: int, edges: list[list[int]]) -> bool:
if len(edges) != n - 1:
return False

parent = [i for i in range(n)]

def find(node):
    p = parent[node]
    while p != parent[p]:
        parent[p] = parent[parent[p]]
        p = parent[p]
    return p
    
def union(n1, n2):
    p1, p2 = find(n1), find(n2)
    
    if p1 == p2:
        return False
        
    parent[p1] = p2
    return True
    
for u, v in edges:
    if not union(u, v):
        return False
        
return True

Create an IAM role that allows the EC2 service to assume it, attach the IAMFullAccess managed policy, and verify the role exists using the AWS CLI.

Interview Question: Calculate Average Order Processing Time for Each Customer

Objective

Your task is to write a SQL query to determine the average order processing time for each customer whose orders have been completed. The average processing time should be calculated in hours. The resul...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Read a Parquet file with nested struct columns using pandas, flatten the nested structures into separate columns with underscore naming, and export the result to CSV format.

Practice window functions and ranking in Snowflake SQL with this hard-level interview question. You join product and sales tables, aggregate revenue, and use DENSE_RANK to find the top 3 products per category. Covers window functions, PARTITION BY, JOINs, SUM, and subqueries in Snowflake. A challenging question seen in data engineering interviews at companies like Coinbase.

Master sequential data analysis in PySpark. Learn how to use the lag() window function to peek at previous rows and track customer purchase history over time.

SQL Query to Calculate Projected Next Salary for Each Employee

Objective

The goal is to write an SQL query that calculates the projected next salary for each employee based on their department's average yearly salary increase percentage. The output should display the employee name, departm...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →

Objective

Write an SQL query to identify the domain of email addresses from a customers table, count the number of occurrences of each domain, and then return the results sorted by the count in descending order. In case of a tie in the count, sort the domains alphabetically.

Additional In...

🔒 Premium Content

Detailed explanation and solution available for premium members.

Upgrade to Premium →