Module assessment

Tables, columns, and foreign keys

Things (entity types), facts (properties), and connections (relationships)

Lakehouses, warehouses, and semantic models

To move data from lakehouses to warehouses

To visualize relationships between entities in a graph

To process natural language questions and generate queries grounded in ontology definitions

Data binding copies data into a centralized warehouse, while ETL leaves data in place

Data binding creates a semantic layer that references data in place, while ETL copies and transforms data into a warehouse

Data binding and ETL are the same process with different names

Ontology items

Data agents

Graph in Microsoft Fabric

Entity types are tied to specific databases and schemas

Entity types are reusable logical models that exist independently of any storage system

Entity types can only contain static data, not time-series data