Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with optimizing a semantic model that contains a large number of relationships between tables. The model is experiencing performance issues due to the complexity of these relationships. Considering the need for cost efficiency, compliance with data governance policies, and scalability for future growth, which of the following steps would you take to optimize the performance of the semantic model? Choose the best option from the following:
A
Remove all the relationships between tables and replace them with many-to-many relationships, as this simplifies the model structure and reduces processing time.
B
Analyze the relationships and refactor them to use more efficient join types and conditions, ensuring that the model remains accurate and performant.
C
Disable the automatic processing of the relationships and manually trigger the processing when needed, to reduce the load on the system during peak hours.
D
Increase the memory allocation for the semantic model processing engine to handle the complex relationships, without making any changes to the model itself.