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 C. an IDENTITY column. Use IDENTITY to create surrogate keys using dedicated SQL pool in AzureSynapse Analytics. Note: A surrogate key on a table is a column with a unique identifier for each row. The key is not generated from the table data. Data modelers like to create surrogate keys on their…

Submitted by chen.hong· Mar 30, 2026Design and implement data storage

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

Aa GUID column
Ba sequence object
Can IDENTITY column

How the community answered

(39 responses)

A
10% (4)
B
18% (7)
C
72% (28)

Explanation

Use IDENTITY to create surrogate keys using dedicated SQL pool in AzureSynapse Analytics. Note: A surrogate key on a table is a column with a unique identifier for each row. The key is not generated from the table data. Data modelers like to create surrogate keys on their tables when they design data warehouse models. You can use the IDENTITY property to achieve this goal simply and effectively without affecting load performance. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-tables-identity

Topics

#surrogate key#IDENTITY column#Azure Synapse#dimension table

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice