Free DP-600 flashcards

To ingest from an on-premises SQL Server with no public endpoint into a Fabric Lakehouse via Dataflows Gen2, which component bridges the cloud service to the private source?

An on-premises data gateway installed on a machine inside the corporate network, registered to the tenant and bound to the connection. It runs behind the firewall and relays query and result traffic between the cloud Microsoft Fabric service and a source the service cannot reach directly, so it is mandatory for any on-premises ingestion.

A cloud connection in the Fabric portal can reach an on-premises SQL Server using stored organisational account credentials.

A cloud connection only reaches sources that already expose a public or service endpoint. It has no presence inside the private network, so it cannot tunnel into an on-premises server the cloud service cannot see. An on-premises data gateway is required to bridge that gap.

In Microsoft Fabric, which is the lowest workspace role that lets someone author reports, semantic models, and a Lakehouse but not manage users or settings?

Contributor. Fabric workspace roles are cumulative: Viewer reads only, Contributor adds full create and edit rights for all item types, Member adds sharing and user management, and Admin adds governance. Contributor is therefore the least-privilege tier that grants authoring while withholding access and settings management.

The Viewer workspace role in Microsoft Fabric is enough to author reports, semantic models, and a Lakehouse.

Wrong. Viewer is read-only: it lets users open and consume items but never create or edit them. Authoring those items needs at least the Contributor role.

Which semantic model storage mode gives import-grade in-memory speed and near real-time freshness over OneLake Delta tables without copying data or scheduled refresh?

Direct Lake reads Parquet-backed Delta tables straight from OneLake and pages columns into memory at query time. This delivers import-like performance while reflecting source updates with no scheduled refresh and no duplication of the data into the model.

Import mode can give near real-time freshness over OneLake Delta data because scheduled refresh keeps reports close to the source.

Import copies the Delta tables into the model and depends on scheduled refresh, so data is duplicated and reports lag between refreshes. It cannot meet a near real-time requirement; Direct Lake serves fresh OneLake data in memory without copying.