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…

The correct answer is A. an IDENTITY column. Dedicated SQL pool supports many, but not all, of the table features offered by other databases. Surrogate keys are not supported. Implement it with an Identity column. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-tables-overview

Submitted by tarun92· Mar 6, 2026Optimize query performance

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?

Options

Aan IDENTITY column
Ba GUID column
Ca sequence object

How the community answered

(45 responses)

A
82% (37)
B
13% (6)
C
4% (2)

Explanation

Dedicated SQL pool supports many, but not all, of the table features offered by other databases. Surrogate keys are not supported. Implement it with an Identity column. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-tables-overview

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice