Chapter 12 – Data Modeling and Managing Relationships

1. C – Data modeling – The primary focus of managing relationships in Power BI is data modeling. This involves structuring data tables, creating relationships between them, and ensuring a proper foundation for analysis.
2. B – It can enhance capabilities but may lead to errors and performance issues – Bidirectional cross-filtering (BDCF) is considered a double-edged sword because while it can enhance analytical capabilities, it may introduce errors and performance issues if not used carefully.
3. B – A feature allowing tables to filter each other in both directions – Bidirectional cross-filtering is a feature in Power BI that allows tables to filter each other in both directions, providing more flexibility in data analysis.
4. B – It defines the nature of relationships between tables – Understanding cardinality is crucial in Power BI data modeling as it defines...