Skip to content

Latest commit

 

History

History
40 lines (27 loc) · 1.34 KB

README.md

File metadata and controls

40 lines (27 loc) · 1.34 KB

🎯 Interview Process Overview

The interview consists of two parts:
1️⃣ Pre-work
2️⃣ Interactive Interview

📝 Pre-work Instructions

⚙️ Interview Environment Setup

The pre-work will utilize the free Databricks Community Edition (you are also welcome to use your company's environment if it is easier).
📎 Attached: Instructions for the Community Edition setup.

You can use a simple demo dataset of your choice for this task.

🚀 Task Overview

📊 Scenario:

  • Customers place orders.
  • Each order can have multiple line items for different products, quantities, and statuses.
  • When the complete order is delivered, it is marked as Completed.
  • Track the status at the item level.

Task 1:

🔧 Design a data model for this system and define the entity-relationship between the objects.

Task 2:

🔍 Provide SQL queries to find the most sold product in the last month.

📐 Additional Instructions

  • Design the data model and create a logical architecture for it.
  • Build a SQL query to find the most sold product in the last month.
  • Be prepared to explain your query during the interview.
  • Do NOT create any additional documentation or slides demonstrating your knowledge of Databricks.