2.1 — Connect To and Discover Data
DP-600 Domain 2 · Skill 2.1
What You Need to Know
Preparing data starts with finding it and connecting to it securely. Fabric gives you catalogs for discovery and reusable connections for access.
Discover data
| Tool | What it shows | Use it to |
|---|---|---|
| OneLake catalog | Every item you can access across the tenant (lakehouses, warehouses, semantic models, reports and more), with filters for domain, item type, owner, endorsement and tags | Find an existing certified model or curated lakehouse before building a new one, and see an item's lineage, description and permissions |
| Real-Time hub | Data streams (eventstreams, KQL tables), Fabric events (OneLake, workspace item, job, capacity) and Azure events (Blob Storage), plus connectors to streaming sources | Find streaming data, or subscribe to events that trigger actions |
| Get data pickers in Desktop and in dataflows | The OneLake catalog, inside the authoring tools | Connect to endorsed Fabric items without leaving the editor |
Endorsement badges (Promoted, Certified, Master data) and domains decide what shows up first. Good governance makes discovery work.
Connect to data
- A connection stores the source, its authentication (OAuth, service principal, key, user name and password, workspace identity) and an optional gateway. It's managed in Manage connections and gateways and shared by pipelines, dataflows, Copy jobs and semantic models.
- Who can use a connection is controlled separately (Owner, User, User with resharing). A colleague can run your pipeline only if they can use its connections.
- Gateway choice: on-premises sources use the on-premises data gateway. Azure sources behind private endpoints use a VNet data gateway. Public cloud sources need no gateway.
- Workspace identity: a managed identity for the workspace, which you can use to authenticate to firewall-protected ADLS Gen2 (trusted workspace access) without storing secrets.
Access data in place, or ingest it?
| If the requirement says | Then |
|---|---|
| "Don't duplicate the data", "always current", the source is ADLS, S3, GCS or another Fabric item | Shortcut (lesson 2.2) |
| Near real-time copy of an operational database, no pipelines | Mirroring |
| Data must be transformed, historized, or moved on a schedule | Ingest with a pipeline, dataflow, notebook or Copy job |
| Events arrive continuously | Eventstream into an eventhouse or lakehouse |
Key Concept: Look in the OneLake catalog before you build anything. Connect through managed connections (with the right gateway). Shortcut when you can, and copy only when you must.
Exam Traps
- Building a new semantic model when a certified one already exists in the catalog
- Looking for streaming sources and OneLake events in the OneLake catalog instead of the Real-Time hub
- Sharing a pipeline without sharing (or granting use of) the connections it relies on
- Using an on-premises gateway for a public cloud SaaS source
Check your understanding
Practice Scenario
🔒 This practice scenario is part of Skillmarked Pro
The lessons stay free. Pro unlocks the other 17 DP-600 practice scenarios and the 50-question timed mock exam, plus everything for every other exam.
Launch Deal: first month €9.95, then €19.90/month. Enter code LAUNCH50 at checkout. Ends 1 December.
Cancel anytime. Or €199 a year, which saves 17%.
Not sure yet? Try 10 free mock exam questions.
Already Pro? Log in.
Sources
- Discover and explore Fabric items in the OneLake catalog, Microsoft Learn
- Introduction to the Fabric Real-Time hub, Microsoft Learn
- Data source management (connections and gateways), Microsoft Learn
- Workspace identity, Microsoft Learn