
Ultimate access to all questions.
You need to design an Azure Synapse Analytics dedicated SQL pool to model employee data. The design must meet these requirements:
Retrieve an employee record as it existed at any specific point in time.
Provide access to the most current employee information.
Minimize the complexity of queries.
What data modeling approach should you use?
A
as a temporal table
B
as a SQL graph table
C
as a degenerate dimension table
D
as a Type 2 slowly changing dimension (SCD) table