Mohamed A. Adel.

Phase 2 Exam — SQL, Power BI & DAX

Topic 11 of 12 · In Business Intelligence · September 12, 2026

⏱ 75 minAssessment

Cumulative exam for Phase 2: correct-grain SQL KPIs, window functions and CTEs, star-model Power BI, measures, RLS, and advanced context-aware DAX.

++++FREE LEARNING PATHBUSINESS INTELLIGENCBUSINESS INTELLIGENCE · PHASE 2 · INTERMEDIATEPHASE 2 EXAM — SQL,POWER BI & DAXCumulative exam for Phase 2: correct-grain SQL KPIs…· 2 / 3ASSESSMENT75 MINmotif / db9121 · 21 · MODULE 2.4

Phase 2 Exam — SQL, Power BI & DAX

This exam closes Phase 2 of the Business Intelligence path — the hands-on core: SQL for Business Intelligence, Power BI Deep Dive and DAX & Advanced Calculations.

Treat it like a real assessment: answer from memory, and read every explanation carefully. You need 70% or higher to pass the phase.

Phase 2 Exam — SQL, Power BI & DAX

Answer all questions. Exam conditions: no notes, no going back, one pressure per question.

0 / 8

Question 1 of 8

Some stores lack a manager mapping in dim_store, but you still need every sale row. Which join and why?

Finished? Review any question you missed, then revisit the related lessons via the hub or roadmap before moving on.