
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)
A
Start by creating the fact table to define all quantitative measures first, then identify and create dimension tables based on the measures defined.
B
Begin with the dimension tables to establish descriptive attributes and hierarchies, then create the fact table to link these dimensions with quantitative measures.
C
Create all tables simultaneously, focusing on defining relationships and constraints as you go, without adhering to a specific order.
D
None of the above, as the order of table creation does not impact the schema's effectiveness.