MicrosoftMicrosoft
DP-203 · Question #13
DP-203 Question #13: Real Exam Question with Answer & Explanation
Sign in or unlock DP-203 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
Submitted by kevin_r· Mar 30, 2026
Question
You need to design an Azure Synapse Analytics dedicated SQL pool that meets the following requirements: - Can return an employee record from a given point in time. - Maintains the latest employee information. - Minimizes query complexity. How should you model the employee data?
Options
- Aas a temporal table
- Bas a SQL graph table
- Cas a degenerate dimension table
- Das a Type 2 slowly changing dimension (SCD) table
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.