Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
You are tasked with designing a star schema for a semantic model in a data warehouse to analyze sales data for a multinational corporation. The schema must support complex queries across various dimensions such as time, geography, and product categories, while ensuring optimal performance and scalability. Considering the need for efficient data retrieval and analysis, which of the following approaches should you follow to create a star schema effectively? (Choose one correct option)
You are tasked with designing a star schema for a semantic model in a data warehouse to analyze sales data for a multinational corporation. The schema must support complex queries across various dimensions such as time, geography, and product categories, while ensuring optimal performance and scalability. Considering the need for efficient data retrieval and analysis, which of the following approaches should you follow to create a star schema effectively? (Choose one correct option)
Simulated