1.Simple Python Task with JSON Data
2.Incremental Refresh for a Billion-Row Table
3.Ride Share App Database Design and KPIs
4.Data Model Design for a Coffee Shop
5.SQL Query for Roundtrip Flights
6.Probability of Drawing Target Cards from Piles
7.Implement K-Means Clustering Algorithm
8.Describe the bias-variance tradeoff, overfitting, and underfitting in machine learning.
9.Explain the concept of p-value and the difference between type I and type II errors.
10.Vertical Order Traversal of a Binary Tree
11.Meeting Room II Variant
12.Machine Learning Questions and Coding Task
13.Understanding of Databases
14.Array Comparison and Filtering
15.Knowledge of Database Management
16.Retrieving Highest Salaries Using SQL
17.SQL Joins and Group By
18.Relational Database vs NoSQL
19.Database Normalization
20.Simple SQL Query
21.Database Knowledge
22.Database Joins and Indexes
23.ML/Coding Interview
24.ML/Case Study Interview
25.ML Depth Interview
26.Technical Proficiency Quick Check
1. Simple Python Task with JSON Data
Given a JSON object, write a simple Python script to find the names of users who meet a certain condition.
2. Incremental Refresh for a Billion-Row Table
How would you tune the performance of an incremental refresh on a table with a billion rows?
3. Ride Share App Database Design and KPIs
Design a database for a ride-sharing app and think of some useful KPIs.
4. Data Model Design for a Coffee Shop
Design a database for a coffee shop and write a query to select the top 3 most popular products, sorted by the number of sales or the amount of revenue generated.
5. SQL Query for Roundtrip Flights
Given a table of flight data, write an SQL query to select all flights that have a roundtrip.
解锁更多真题，请点此 登录 篱笆帮
高频题（0）
