Question 1

Azure Fabric in Cloud Architecture?

Accepted Answer

**Section 1 — The Context (The 'Why')**
The primary challenge for this design in Cloud/Tools is balancing scale, cost, and reliability. At scale, naive approaches fail: single points of failure cause cascades, schema evolution breaks consumers, and over-provisioning explodes cost. Failure modes include silent data loss from non-idempotent writes, cascading job failures from tight coupling, and operational burden from manual intervention....

Question 2

Azure Functions vs. Logic Apps?

Accepted Answer

Why choose: Different abstraction levels—code vs. workflow. Functions: code-first, serverless; custom logic, APIs, event-driven. Logic Apps: low-code, 400+ connectors; designer-driven. When Functions: complex transforms, code reuse, fine-grained control. When Logic Apps: orchestration with minimal code, SaaS integration, non-devs modifying flows. Scalability: Functions scale with demand; Logic Apps have execution limits (e.g., 90-day run history)....

Question 3

Agile in project management?

Accepted Answer

**Agile**: Iterative development in sprints. Collaboration and adaptability. **Roles**: PO, Scrum Master, team. **Ceremonies**: Planning, standup, review, retro. **Data deliverables**: Pipelines, datasets, quality....

Question 4

Find orders exceeding $1,000 in the last 30 days.

Accepted Answer

**SQL**: WHERE amount > 1000 AND order_date >= CURRENT_DATE - INTERVAL '30 days'. Index on (amount, order_date). Parameterize dates for testing. For streaming: watermark + window agg.

Question 5

Find top 3 products sold based on total quantity.

Accepted Answer

**SQL**: GROUP BY product, SUM(quantity), ORDER BY total DESC LIMIT 3. Or RANK() OVER (ORDER BY SUM(quantity) DESC) with filter rk <= 3. RANK handles ties (same rank); DENSE_RANK for consecutive ranks.

Question 6

List customers with more than 5 orders.

Accepted Answer

**Why HAVING vs WHERE:** WHERE filters before aggregation; HAVING after. For 'more than 5 orders,' you must aggregate first—HAVING is correct. Using WHERE with a subquery is an alternative but less clear.

**Scalability:** (1) Index customer_id, order_id—enables index-only scan for COUNT. (2) For billions of rows: pre-aggregate in a summary table (customer_order_counts) refreshed incrementally....

Question 7

Python list operations.

Accepted Answer

**Core Operations:** Indexing, slicing (lst[i:j:k]), append, extend, insert, remove, pop, sort, reverse. Membership (in) is O(n); for repeated lookup use set.

**Gotchas:** lst.reverse() and lst.sort() mutate in-place, return None. reversed(lst) and sorted(lst) return new iterable/list. lst += [1] mutates; lst = lst + [1] creates new. Slice assignment lst[1:3] = [a,b] can change length.

**Production:** Prefer list comprehensions over manual loops. Use bisect for sorted lists....

Question 8

Unix scripting in data engineering?

Accepted Answer

**Why Unix in Data Eng:** File staging, cleanup, lightweight transforms before Spark. find, awk, sed, xargs, cron—ubiquitous, no runtime deps.

**Use Cases:** find /data -name '*.csv' -mtime +7 | xargs gzip. awk -F',' '{print $1,$3}' for column extraction. sed for bulk replace. Cron for scheduling: 0 2 * * * /scripts/ingest.sh.

**Scalability:** Shell for single-node, pre-processing. For distributed: Spark. Best practice: set -e (exit on error), validate paths, log to file....

Comcast Data Engineer Interview Questions

Reading isn't practice. Get AI feedback on your answers.

Other Companies

Comcast Data Engineer Interview Questions

Reading isn't practice. Get AI feedback on your answers.

Other Companies