# Data Engineer interview question: design tables and a daily metrics pipeline

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/7150/design-tables-pipeline-daily-metrics
Source observed: 2026-11-04T23:47:43.620Z
Last checked: 2026-11-04T23:47:43.62+00:00
Indexed: 2026-11-05T19:25:55.305+00:00

---

# Design tables and a processing pipeline for daily listening metrics

We provide interview practice through Aced, formerly Exponent. This question asks you to design tables and a processing pipeline that support daily metrics including:

- Unique listeners
- Play count
- Total listening time
- Top artists by country

## Question details

- **Role:** [Data Engineer](https://www.aced.io/questions?role=data-engineer)
- **Categories:** [Data Modeling](https://www.aced.io/questions?type=data-modeling) and [Data Pipeline Design](https://www.aced.io/questions?type=data-pipeline-design)
- **Interview record:** 1 interview; reported last asked 2 years ago
- **Company associated with the question:** [Spotify](https://www.aced.io/questions?company=spotify)

Detailed company statistics are available through [Upgrade](https://www.aced.io/upgrade?src=questions).

## Interview experience

One shared experience is available for [Spotify](https://www.aced.io/experiences/spotify-data-engineer-interview-478a81):

> “Friendly interviewers, thorough with their questions. Questions focused on GCP, BigQuery, Apache Beam (Dataflow)”

The experience concerns a **Data Engineer** interview at **Mid Level / L4** and was shared 2 years ago.

## Community answers

No answers have been contributed by the community yet.

## Related courses

### [Data Engineering Interview Prep](https://www.aced.io/courses/data-engineering)

We help candidates prepare for data engineering roles at Meta, Google, Amazon, Microsoft, Walmart, DoorDash, and other top companies. The course covers mock interviews, frameworks, and advice from senior candidates, with practice in data modeling, pipeline design, SQL, coding, behavioral interviews, and more.

![Data Engineering Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/5XoOCgXlGqN2fa1zaroNWd/9a2e23df48a212bc00d352873feb2d6a/Data_Engineer_Interview_Prep_Hero_Image.jpg?w=800&h=800&fm=webp&q=75)

### [Behavioral Interviews: A Practical Guide for Engineers](https://www.aced.io/courses/eng-behavioral)

We help candidates prepare for senior and higher-level behavioral interviews at FAANG and Tier-1 companies. The course was made with staff and principal engineers from Meta, Netflix, Google, and more, and covers avoiding downleveling, elevating past projects, and communicating naturally.

![Behavioral Interviews: A Practical Guide for Engineers](https://images.ctfassets.net/x78yjrjc11pq/47qcoHjzFZXE37GoacedkB/9d8e3f4910d8b06b21e76745cd9cbff3/AdobeStock_1142146335.jpeg?w=800&h=800&fm=webp&q=75)

## Submit an answer

You can add your own answer in the editor. Available formatting includes bold, italic, bulleted lists, numbered lists, quotes, inline code, and code blocks. Submitting marks this question complete.

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F7150%2Fdesign-tables-pipeline-daily-metrics&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F7150%2Fdesign-tables-pipeline-daily-metrics). Opening a form does not execute a tool.