Microsoft Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
4Questions
1Company
4 Questions 1 Company
Showing 4 results
Microsoft
Medium
Data ScientistQuery email logs for deliverability insights
Using the schema and sample data below, write SQL to answer parts a–c. Assume timestamps are UTC. Today is 2025-09-01. Schema: - Emails(sent_id INT, m...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025
Microsoft
Medium
Data ScientistFind common friends from directed edges
You have a directed edge list that records who followed whom. A mutual “friendship” exists only if both directions appear (A→B and B→A). Schema and sa...
Data Manipulation (SQL/Python)
0
0
Oct 13, 2025
Microsoft
Medium
Software EngineerCompute most popular location with weights
You are given a dataset of voting records for concert locations. Each record includes voter_id, location_text, and an optional numeric weight (default...
Data Manipulation (SQL/Python)
0
0
Sep 6, 2025
Microsoft
Medium
Software EngineerCount words in a document robustly
Given a text document, return the number of words under a precise definition. First, state the tokenization rules you will use (e.g., treat contractio...
Data Manipulation (SQL/Python)
0
0
Aug 14, 2025