QuestionQ128
Data Modeling with Databricks SQLA company uses a star schema to analyze sales information. The sales fact table stores transactions, and the dimension tables include products, stores, and dates.
How do primary and foreign keys support efficient joins between these tables?
- A The fact table and dimension tables are joined using arbitrary columns, and primary/foreign key relationships are not required in a star schema.
- B The fact table contains primary keys that directly match the primary keys in each dimension table, allowing for one-to-one joins.
- C Both fact and dimension tables use only foreign keys, and joins are performed using non-unique columns.
- D Each dimension table has a primary key, which is referenced as a foreign key in the fact table. This structure allows the fact table to join with multiple dimension tables for analytical queries.
Community Discussion