You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should you create?
B. A table that has an IDENTITY property
Here’s why:
A surrogate key is a unique identifier for a record, and in SQL Server, the IDENTITY property is the most commonly used method to create surrogate keys. It automatically generates unique, sequential numbers, which is ideal for a surrogate key.
The requirement to account for changes to the retail store addresses suggests the need for a unique identifier that remains consistent even if store addresses change. An IDENTITY column is perfect for this because the values will not change as the data in the other columns (like the store address) changes.
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
bingomutant
7 months agoTheSwedishGuy
11 months, 3 weeks agoxegiwo9758
3 years, 4 months agoo2091
3 years, 6 months ago