DP-300 Certification Practice Question #173

Question

You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool.
You need to create a surrogate key for the table. The solution must provide the fastest query performance.
What should you use for the surrogate key?

Accepted Answer

To implement a surrogate key in an Azure Synapse dedicated SQL pool table with the fastest query performance, you should use an `IDENTITY` column (Option A). Dedicated SQL pools do not support SQL Server sequence objects (Option C). While GUIDs (Option B) are supported, they have a larger storage footprint (16 bytes) and introduce severe performance degradation during joins and aggregations compared to integer-based identity columns.

More DP-300 practice questions