Black Friday50% off your first month on any monthly plan with EARLY50 See plans
All 35 lessons
  1. Start here: cloud, data, Fabric and Power BI basics

    1. 1. Start here: the exam, the plan and what you already know
    2. 2. Cloud in plain words: SaaS, PaaS, IaaS and where Fabric fits
    3. 3. Data basics: files, tables, formats and the lakehouse idea
    4. 4. A tour of Microsoft Fabric: OneLake, workspaces and items
    5. 5. Power BI in plain words: semantic models, reports and DAX
  2. Prepare data: get data in (exam area 2, 45-50%)

    1. 6. Connect to data and find it: connections, gateways, OneLake catalog and Real-Time hub
    2. 7. Choosing a data store: lakehouse, warehouse or eventhouse
    3. 8. Use data without copying: shortcuts, mirroring and OneLake integration
    4. 9. Ingest data: Dataflow Gen2, pipelines, Copy job and notebooks
    5. 10. Power Query in Dataflow Gen2: filter, data types, merge and new columns
    6. 11. Messy data: duplicates, missing values and nulls
  3. Prepare data: transform and query (exam area 2)

    1. 12. Views, functions and stored procedures in T-SQL
    2. 13. Build a star schema in a lakehouse or warehouse
    3. 14. Aggregate, join and enrich: SQL and PySpark side by side
    4. 15. Query with the Visual query editor and SQL
    5. 16. Query with KQL
    6. 17. Query with DAX: DAX query view and EVALUATE
  4. Design and build semantic models (exam area 3, 25-30%)

    1. 18. Choose a storage mode: Import, DirectQuery, Direct Lake and Dual
    2. 19. Relationships: star schemas, bridge tables and many-to-many
    3. 20. DAX foundations: measures, filter context, CALCULATE and variables
    4. 21. DAX functions the exam tests: iterators, table filters, windows and information functions
    5. 22. Calculation groups, dynamic format strings and field parameters
    6. 23. Composite models and large semantic model storage format
  5. Optimize models, then secure them (exam areas 3 and 1)

    1. 24. Direct Lake in depth: fallback, refresh and the two flavors
    2. 25. Incremental refresh for semantic models
    3. 26. Faster reports and DAX: finding and fixing slow queries
    4. 27. Who can see what: workspace roles and item permissions
    5. 28. Fine-grained security: rows, columns, objects and files
    6. 29. Governance: sensitivity labels and endorsement
  6. Lifecycle, then exam practice (exam area 1)

    1. 30. Version control: Git integration and Power BI projects (.pbip)
    2. 31. Deployment pipelines and impact analysis
    3. 32. XMLA endpoint and reusable assets: .pbit, .pbids and shared semantic models
    4. 33. Mock exam 1
    5. 34. Final review and exam day: every decision on one page
    6. 35. Mock exam 2
See the leaderboard

14 min

Cloud in plain words: SaaS, PaaS, IaaS and where Fabric fits

Explain what the cloud is and why Fabric is a SaaS product, so later lessons make sense.

By the end of this lesson you can

  • Tell IaaS, PaaS and SaaS apart, with a Microsoft example of each
  • Explain why Fabric being SaaS means you never manage servers
  • Define tenant, capacity, F SKU and region, and pick the Power BI license a person needs
  • Say what Microsoft Entra ID does when you sign in to Fabric

From earlier lessons · 1 of 3

Your DP-600 score report shows 700. Did you pass?

Pick one answer.

From earlier lessons · 2 of 3

Which DP-600 skill area carries the most weight?

Pick one answer.

From earlier lessons · 3 of 3

During DP-600 you open Microsoft Learn to check a DAX function. What happens to the exam clock?

Pick one answer.

Juniper Coffee's finance director stops by your desk. "IT says we need servers for this Fabric thing. How many, and who patches them? And do all 120 store managers need a paid license?" You open the Fabric portal and look for a server to count. There isn't one.

[6]

Cloud computing: renting instead of owning

Exam depth: recognize it.

Cloud computing is the delivery of computing services over the internet. Those services include servers, storage, databases and networking.

The old way was to own the computers. You bought servers months ahead, sized for your busiest day, and kept them running all year. In the cloud you rent what you need when you need it. When the holiday rush starts, you add computing power. When it ends, you scale back and stop paying for it.

Microsoft's cloud is called Azure. Fabric runs on it.

[13]

IaaS, PaaS and SaaS: who runs what

Exam depth: recognize it.

Cloud services come in three models. They differ in how much the provider runs for you.

ModelWhat you manageMicrosoft example
IaaS, infrastructure as a serviceVirtual machines, their operating systems and your apps.Azure Virtual Machines.
PaaS, platform as a serviceYour app and its settings. No machines or operating systems.Azure SQL Database.
SaaS, software as a serviceOnly your data, users and settings. You use a finished app.Microsoft 365.

A virtual machine is a computer simulated in software, rented by the hour. An operating system is the base software it runs, such as Windows or Linux.

In every model, three things stay yours: your data, your users and your settings.

Decision rule: the more you want to control, the further toward IaaS you go. The less you want to run, the further toward SaaS.

[14][15]

Match

Match each Microsoft service to its cloud model

Pick an item on the left, then its match on the right.

[14]

Fabric is SaaS: no servers to run

Exam depth: know it cold.

Fabric is delivered as SaaS, built on Azure. You sign in through a web browser and create things. Microsoft runs the machines underneath.

That shapes your job as an analytics engineer:

  • You never install, patch or size a server.
  • You never build a cluster, a group of machines that share one big job. Fabric provides the engines that store data, run queries and refresh semantic models.
  • Many security and compliance features are built in, with little or no setup.

Older data products were mostly PaaS. Each service needed its own setup. In Fabric, the services share one platform and one copy of your data.

What's still yours: your data, who can see it, and the settings of what you build.

[8][16]

[8]

You are an analytics engineer at Juniper Coffee. The IT team is two people and can't take on server maintenance. The company needs a place to store sales data and serve Power BI reports. You need the option with the least infrastructure to manage. What should you choose?

Pick one answer.

[8][14]

Tenant, capacity and F SKUs: what you pay for

Exam depth: know it cold.

A tenant is your organization's single instance of Fabric. It's tied to your organization's sign-in directory, which Microsoft creates when you first get any Microsoft online service.

A capacity is a pool of compute inside the tenant. Compute is the processing power that runs queries, refreshes and jobs. A tenant can have as many capacities as it needs.

You buy a capacity as an F SKU. A SKU is a product size. F SKUs run from F2 up to F8192. The number is its capacity units (CUs), Fabric's measure of compute: F64 has 64 CUs.

F capacities are bought through Azure and billed per second, with a one-minute minimum and no commitment. You can reserve one for a year to pay less.

A workspace is where a team builds its items. Each workspace runs on one capacity.

To try Fabric, a Fabric Trial gives 64 CUs for 60 days.

[2][9]

Rendering diagram…
One tenant, several capacities. Each workspace runs on exactly one capacity.

[9]

Power BI licenses: Free, Pro and PPU

Exam depth: recognize it.

A capacity pays for compute. A per-user license decides what one person may do. My workspace is each user's personal workspace.

LicenseWhat it allows
FreeGiven on first sign-in. Create non-Power BI items, such as Lakehouses, on an F or trial capacity. View Power BI content only on F64 or larger, with the Viewer role.
ProCreate Power BI items outside My workspace and share them. On capacities below F64, every viewer needs Pro (or PPU).
Premium Per User (PPU)Most Power BI Premium features, licensed per person.

Decision rule: building or sharing Power BI content needs Pro or PPU. Only viewing, on F64 or larger, needs Free plus the Viewer role.

[9]

[9]

You are an analytics engineer at Juniper Coffee. 120 store managers will view a sales report. They have only Free licenses, and finance won't buy them Pro. You need the smallest capacity that lets them view it. What should you choose?

Pick one answer.

[9]

Regions and data residency

Exam depth: recognize it.

A region is a group of Microsoft datacenters in one area, such as East US or West Europe.

Your tenant has a home region. It's set when the tenant is created, from where the first user signed up. It's the default place your data is stored.

Data residency means rules about where data may be stored. For example: EU customers' data must stay in the EU.

To meet a rule like that, create a capacity in the region you need. Then assign the workspace to it. That workspace's data is stored and processed in the capacity's region. Some tenant-wide information stays in the home region, such as metadata: the names and settings of your items.

[17][18][19][20]

The About Microsoft Fabric window, opened from the Help pane. It lists service version and tenant URL, and a highlighted line reads "Your data is stored in" followed by the region.
Microsoft Learn, CC BY 4.0

[17]

You are an analytics engineer at Juniper Coffee, whose Fabric home region is in the US. Juniper opens cafés in Ireland, and their loyalty data must be stored in the EU. You need to meet this rule with the least change to the rest of the setup. What should you do?

Pick one answer.

[18][19][20]

Microsoft Entra ID: who you are

Exam depth: recognize it.

Microsoft Entra ID is Microsoft's cloud service for identity and access. It checks who you are when you sign in. Its old name was Azure Active Directory.

Every sign-in to Fabric goes through Entra ID, and your Fabric tenant is tied to your organization's Entra tenant.

  • A user is one person's account, such as a store manager's.
  • A group is a named set of users, such as North region managers.

Fabric then decides what each user or group may do, through roles and permissions you'll meet in lessons 27 and 28. Granting access to a group, not to each person, keeps it manageable.

[2][21][22][23]

Finance asked how many servers. The answer was a slider. Picture: Retro pixel art, 16-bit video game style.

Exam-style practice

You are an analytics engineer at Juniper Coffee. The Store reports workspace runs on an F64 capacity. You have a Free license, and you must publish a new semantic model to that workspace and share it. You need the cheapest change that lets you do this. What should you get?

Pick one answer.

[9]

You are an analytics engineer at Juniper Coffee. The development capacity, an F8, is used only on weekdays from 9 to 6. You need to cut its cost at nights and weekends without deleting any data. What should you do?

Pick one answer.

[24][25]

You are an analytics engineer at Juniper Coffee. Heavy nightly data loads slow down the store managers' reports, which share the same capacity. You need to stop the loads from affecting the reports. Users must keep one sign-in. What should you do?

Pick one answer.

[9][26]

FlashcardsIndex cardsFlashcards ⚡

Card 1 of 15

[2][8][9][13][14][17][21]

Worth keeping

  1. IaaS: you run the machines. PaaS: you run the app. SaaS: you just use it.
  2. Fabric is SaaS, so you never install, patch or size servers.
  3. One tenant holds many capacities; each workspace runs on one capacity.
  4. Builders need Pro or PPU; on F64 and up, Free users with Viewer can view. PPU is not a capacity.
  5. A workspace's data lives in its capacity's region; Entra ID handles every sign-in.

You know where Juniper's data will live and what powers it. But that data comes as CSV price lists, JSON app events and database tables. Next lesson: which format is fastest for analysis, and why Fabric stores every table as Delta.

Leaderboard

Loading…

50 XP for each lesson you finish, 10 for each right answer. Names show only for learners who turn on Show me on leaderboards.

Sources for this lesson (20)

Each fact in the lesson is marked with the number of the page it comes from.

  1. [2]Microsoft Learn: Fabric terminology
  2. [3]Microsoft Learn: Exam duration and exam experience
  3. [4]Microsoft Learn: Exam scoring and score reports
  4. [6]Microsoft Learn: Study guide for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
  5. [8]Microsoft Learn: What is Microsoft Fabric?
  6. [9]Microsoft Learn: Understand Microsoft Fabric licenses and capacity
  7. [13]Microsoft Learn: What is cloud computing
  8. [14]Microsoft Learn: Shared responsibility in the cloud
  9. [15]Microsoft Learn: Describe Software as a Service
  10. [16]Microsoft Learn: Microsoft Fabric security fundamentals
  11. [17]Microsoft Learn: Find your Fabric home region
  12. [18]Microsoft Learn: Power BI implementation planning: Tenant setup
  13. [19]Microsoft Learn: Configure Multi-Geo support for Fabric
  14. [20]Microsoft Learn: Microsoft Fabric end-to-end security scenario
  15. [21]Microsoft Learn: What is Microsoft Entra?
  16. [22]Microsoft Learn: Microsoft Entra service description
  17. [23]Microsoft Learn: Security in Microsoft Fabric
  18. [24]Microsoft Learn: Pause and resume your Fabric capacity
  19. [25]Microsoft Learn: Pause and resume in Fabric Data Warehouse
  20. [26]Microsoft Learn: Evaluate and optimize your Microsoft Fabric capacity