Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
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)
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)
Explanation:
Establishing a one-to-many relationship from the 'Regions' dimension table to the 'Shipments' fact table is the most appropriate approach. This setup accurately reflects the real-world scenario where each shipment is destined for a single region, enabling efficient and accurate analysis of shipment volumes per region. A many-to-many relationship (Option A) is unnecessary and could complicate the model without providing additional benefits. Not defining any relationship (Option C) would hinder the ability to perform regional analysis effectively. While creating a custom measure (Option D) might offer a workaround, it lacks the efficiency and clarity of a properly defined relationship.