Archives: Assignments
Description.
Bonus Part 2 – Advanced Individual
Part 1 Individual Assignment
Part 2
Team Task Breakdown – Sales Analytics Challenge (Part 2) Team Structure Teams consist of 4–5 students Each team
Part 1 Bonus
Part 1 Bonus BONUS EXERCISE – PART 1 Build Your Own Azure SQL Database & Load the Superstore
Part 1
Part 1 – Individual Mini Exercises (10 Tasks) Time: ~60 minutes total Each student must complete all 10.
Task v2 MERGE-Based Pipeline (Upsert)
Problem Statement Your current INSERT-only task is not safe for repeated execution because it can create duplicate records
Marketing Campaign Analysis with Snowflake Marketplace Data
— ============================================================================— STUDENT EXERCISE: Marketing Campaign Weather Impact Analysis— Complete the tasks below by filling in the “YOUR
Bonus Question: Filtering
From the sample dataset, how many unique orders have a ‘payment_failed’ status? A) 1 orderB) 2 ordersC) 3
Recovering a Table Using Clone + Swap
In the previous lesson, you created a backup (BU) table using zero-copy cloning. That clone represents a clean,