Question 10
DP-203 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →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?
- Aas a temporal table
- Bas a SQL graph table
- Cas a degenerate dimension table
- Das a Type 2 slowly changing dimension (SCD) table