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.