Archives: Assignments

Part 1 Bonus BONUS EXERCISE – PART 1 Build Your Own Azure SQL Database & Load the Superstore

Part 1 – Individual Mini Exercises (10 Tasks) Time: ~60 minutes total Each student must complete all 10.

Problem Statement Your current INSERT-only task is not safe for repeated execution because it can create duplicate records

Overview In this lesson, you will work on a real-world data engineering and analytics scenario where marketing performance

From the sample dataset, how many unique orders have a ‘payment_failed’ status? A) 1 orderB) 2 ordersC) 3

In the previous lesson, you created a backup (BU) table using zero-copy cloning. That clone represents a clean,

Scenario You have been working with the table: AE_RETAIL_EVENTS.RAW.ORDER_EVENTS_ENRICHED During a reload exercise, a student accidentally runs a

Business Context During a weekly performance review, the retail analytics team discusses customer shopping behaviour. The Marketing Lead

Business context The Retail Operations Lead asks: “Do customers behave differently on weekends compared to weekdays?” Business requirement

This assessment validates your ability to: Use a project view as the source of clean event data Join