# Build a medallion data model for retail data | Aced

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/6635/build-medallion-model-retail-data
Source observed: 2026-11-04T21:34:35.119Z
Last checked: 2026-11-04T21:34:35.119+00:00
Indexed: 2026-11-05T01:59:23.442+00:00

---

# Build a medallion data model for retail data

We provide this data-engineering interview question for candidates preparing for technical interviews. The prompt asks you to walk through each medallion-model layer, define the primary key (PK) and partition key, and explain how to enable fast lookup.

- **Role:** [Data Engineer](https://www.aced.io/questions?role=data-engineer)
- **Company:** [Amazon](https://www.aced.io/questions?company=amazon)
- **Category:** [Data Modeling](https://www.aced.io/questions?type=data-modeling)
- **Interview reports:** 1 interview
- **Reported timing:** Last asked 5 months ago

## Access

Detailed company statistics for this question require an upgrade: [Upgrade](https://www.aced.io/upgrade?src=questions).

## Interview experiences

One shared experience is associated with this question:

- [Amazon · 5 months ago — “I definitely had good preparation on LP question which is one of the most important area because company focuses on this a lot”](https://www.aced.io/experiences/amazon-staff-data-engineer-interview-e2ca9d)
  - Role: Data Engineer · Staff / L6

## Community answers

No answers have been contributed by the community yet.

## Related courses

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

![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)

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

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

![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)

We help candidates prepare for senior-plus behavioral interviews at FAANG and Tier-1 companies. Staff and principal engineers from Meta, Netflix, Google, and other companies made the course. It focuses on avoiding downleveling, elevating past projects, and giving natural-sounding answers.

## Submit an answer

Use the **Your answer** area to respond. Submitting marks the 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%2F6635%2Fbuild-medallion-model-retail-data&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%2F6635%2Fbuild-medallion-model-retail-data). Opening a form does not execute a tool.