ЁЯУв Too many exams? DonтАЩt know which one suits you best? Book Your Free Expert ЁЯСЙ call Now!

    Question

    Which of the following best describes a fact

    constellation schema in a data warehouse?
    A A schema with a single large central fact table connected to multiple dimension tables Correct Answer Incorrect Answer
    B A schema where each dimension has its own hierarchy in a tree structure Correct Answer Incorrect Answer
    C A schema consisting of multiple fact tables sharing many dimension tables Correct Answer Incorrect Answer
    D A normalized schema that eliminates redundancy in dimension data Correct Answer Incorrect Answer
    E A schema used only for OLTP systems, not OLAP Correct Answer Incorrect Answer

    Solution

    A fact constellation schema, also known as a galaxy schema, is a complex schema used in a data warehouse where: тАв Multiple fact tables exist (e.g., Sales Fact, Shipment Fact). тАв These fact tables share dimension tables (like Time, Product, Customer). тАв It supports complex business processes that cannot be represented by a single fact table. This schema is more advanced than star and snowflake schemas and is suitable for enterprise-level data warehousing. тАв Option A describes a star schema. тАв Option B vaguely refers to hierarchy in dimensions (e.g., snowflake). тАв Option D refers to normalization, relevant for snowflake schema but not fact constellation. тАв Option E is incorrect because fact constellation is used in OLAP systems.

    Practice Next
    More Data Warehousing Questions
    ask-question