Answer: a dimension table for Employee, a fact table for Transaction

In a star schema design for a data warehouse, the model consists of fact tables and dimension tables. Fact tables contain quantitative data (measures) and foreign keys to dimension tables, while dimension tables contain descriptive attributes that provide context to the facts. **Analysis of the source data fields:** - **Employee descriptive attributes**: EmployeeID, FirstName, LastName, GovernmentID - **Transaction attributes**: TransactionID, Recipient, GrossAmount, NetAmountPaid, TransactionDate - **Relationship**: EmployeeID appears in both contexts, indicating employees are involved in transactions **Optimal design rationale:** **C (Dimension table for Employee)** is correct because: - Employee information (EmployeeID, FirstName, LastName, GovernmentID) represents descriptive, relatively static data - This serves as a dimension that provides context about who performed or is associated with transactions - Employee attributes don't change frequently and are used to filter, group, or describe transaction facts **E (Fact table for Transaction)** is correct because: - Transaction data (TransactionID, GrossAmount, NetAmountPaid, TransactionDate, Recipient) represents measurable events with quantitative values - This table contains the business facts/measures that HR would analyze (payment amounts, transaction counts, etc.) - EmployeeID would serve as a foreign key linking to the Employee dimension **Why other options are incorrect:** - **A (Dimension table for Transaction)**: Transactions are events with measurable quantities, making them better suited as facts rather than dimensions - **B (Dimension table for EmployeeTransaction)**: This would create an unnecessary hybrid table that violates star schema principles - **D (Fact table for Employee)**: Employee data is descriptive rather than quantitative, making it unsuitable as a fact table This design follows star schema best practices where transactions (business events) become fact tables and the entities involved (employees) become dimension tables, enabling efficient analytical queries in Azure Synapse Analytics dedicated SQL pool.

Author: LeetQuiz Editorial Team