DP-203 · Question #167
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
Sign in or unlock DP-203 to reveal the answer and full explanation for question #167. The question stem and answer options stay visible for context.
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.
Options
- Aa dimension table for Transaction
- Ba dimension table for EmployeeTransaction
- Ca dimension table for Employee
- Da fact table for Employee
- Ea fact table for Transaction
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.