
Ultimate access to all questions.
You are designing a star schema for an HR data mart in an Azure Synapse Analytics dedicated SQL pool. The source data extract contains the following fields: EmployeeID, FirstName, LastName, Recipient, GrossAmount, TransactionID, GovernmentID, NetAmountPaid, and TransactionDate.
Which two tables should you create? Each correct answer presents part of the solution.

A
a dimension table for Transaction
B
a dimension table for EmployeeTransaction
C
a dimension table for Employee
D
a fact table for Employee
E
a fact table for Transaction