Microsoft Certified: Fabric Analytics Engineer AssociateImplement and manage semantic models (30-35%)Easy
A data engineer is developing a semantic model in Microsoft Fabric. The model will consume data from multiple sources, including an Azure SQL Database and a REST API. The engineer needs to define relationships between tables from different sources. Which feature in the Power Query Editor or model view allows for the creation of these relationships?
- AParameters and functions
- BAppend Queries transformation
- CMerge Queries transformation
- DModel relationships view
Show answer & explanationAnswer & explanation
Correct answer: D. Model relationships view
Relationships between tables, regardless of their source, are defined in the model view of Power BI Desktop or the semantic model editor in Fabric. This allows the semantic model to understand how data from different tables and sources are interconnected.
Why the other options are wrong
- A. Parameters and functions are used for dynamic data source connections or reusable transformation logic, not for defining relationships between loaded tables.
- B. Append Queries stacks rows from multiple queries into a single table, also at the data transformation stage.
- C. Merge Queries combines data from two queries into a single table at the data transformation stage, not for defining model relationships.
Model Relationships
Connections between tables in a semantic model that define how data from different tables are related, enabling proper filtering and aggregation across the model.
- Crucial for correct data aggregation and filtering.
- Defined by cardinality (one-to-many, many-to-many, etc.) and cross-filter direction.
- Can be active or inactive.
Memory trick: Relationships link, Measures calculate, Tables hold data, Columns describe.