Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool and need to create a surrogate key. The solution must provide the fastest query performance. What should you use for the surrogate key?
A
a GUID column
B
a sequence object
C
an IDENTITY column