
Ultimate access to all questions.
You are tasked with designing a semantic model for a manufacturing company that requires efficient query performance across various financial metrics. The company operates in multiple regions and needs to compare performance across these regions dynamically. To achieve this, you decide to implement calculation groups in your model. Considering the need for scalability, maintainability, and performance, which of the following approaches should you take to effectively use calculation groups in your model? (Choose one correct answer)
A
Develop individual measures for each financial metric and manually group them in the reporting tool, relying on the tool's capabilities to manage performance.
B
Combine multiple financial calculations into a single measure using calculation groups, leveraging the CALCULATE function to dynamically apply filters based on the selected region.
C
Implement a single measure that uses the SWITCH function to return different calculations based on the user's selection, without utilizing calculation groups.
D
Avoid using calculation groups and instead, pre-calculate all possible combinations of financial metrics and regions in the data model.