DP-203 Certification Practice Question #36

Question

You are designing a data mart for the human resources (HR) department at your company. The data mart will contain employee information and employee transactions.
From a source system, you have a flat extract that has the following fields:
✑ EmployeeID

FirstName -

✑ LastName
✑ Recipient
✑ GrossAmount
✑ TransactionID
✑ GovernmentID
✑ NetAmountPaid
✑ TransactionDate
You need to design a star schema data model in an Azure Synapse Analytics dedicated SQL pool for the data mart.
Which two tables should you create? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

Accepted Answer

In a star schema, descriptive employee attributes such as employee ID, name, and government ID belong in a dimension table, while measurable transaction records such as gross amount, net amount paid, and transaction date belong in a fact table. Microsoft Learn describes this exact split between descriptive dimensions and quantitative transaction facts. The community consensus correctly identifies `Employee` as the dimension and `Transaction` as the fact, while the suggested answer appears incomplete because it includes only the fact side.

More DP-203 practice questions