You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should…

Scenario: Implement a surrogate key to account for changes to the retail store addresses.

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.

Reference:

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehousetables-identity