
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are designing a semantic model for a logistics company that operates globally. The company needs to analyze shipping data across multiple regions to optimize routes and reduce costs. The 'Shipments' fact table contains detailed records of each shipment, including destination, while the 'Regions' dimension table categorizes these destinations into broader geographical areas. Given the need for accurate and efficient analysis, which of the following best practices should you implement when creating relationships between these tables? (Choose one correct answer)
A
Implement a many-to-many relationship between the 'Shipments' and 'Regions' tables to allow for complex analytical scenarios.
B
Establish a one-to-many relationship from the 'Regions' table to the 'Shipments' table to ensure that each shipment is linked to a single region, facilitating straightforward regional analysis.
C
Do not define any relationship between the 'Shipments' and 'Regions' tables to maintain flexibility in how data is queried and analyzed.
D
Create a custom measure within the 'Shipments' table that manually assigns each shipment to a region, bypassing the need for a formal relationship.