Exam DP-203 topic 5 question 4 discussion

A surrogate key is a system-generated unique identifier that is used as a substitute for a natural key. In this case, the surrogate key will be used to account for changes to the retail store addresses. By creating a table with an IDENTITY property, you can ensure that a unique surrogate key is automatically generated for each row inserted into the table. The IDENTITY property assigns a unique value to the column automatically, incrementing by one for each new row. Using an IDENTITY column as the surrogate key will provide an efficient way to join and filter sales transaction records based on product ID, as required by the sales transaction dataset requirements.

CREATE TABLE RetailStore ( StoreID INT IDENTITY(1,1) PRIMARY KEY, StoreName NVARCHAR(100), Location NVARCHAR(100) );

is correct

Given answer is correct

Identity should be used.

A is the correct Answer !