Microsoft · DP-900
Transactional and analytical workloads
DP-900 · Lesson 3 of 12 · 12:13
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-900 exam (Microsoft Certified: Azure Data Fundamentals). In this lesson: transactional workloads and ACID, analytical workloads, data warehouses, star schemas, data lakes, and lakehouses, and moving data with ETL and ELT. Includes three original practice questions.
Preview the topics
- A booking system must make sure that a seat is never sold twice, even when two customers click at the same moment. Which property guarantees this?
- In a sales warehouse, which table holds the sales amounts and quantities, linked to date, product, and store tables?
- Heavy monthly reports run directly on the order database, and checkout slows down every time. What should the company do?