Question 80
A service synchronizes offline records and currently uses locally assigned integer IDs that collide during merge. Initial testing shows: Independently created records merge without key collisions at expected scale. Which limitation should the team still consider?
Explanation
Correct Answer
Random GUIDs can increase index fragmentation and storage compared with narrow integers. A globally unique identifier can support disconnected key generation but affects index locality. Use a supported UNIQUEIDENTIFIER strategy with careful clustering and validation.
Incorrect Answers
A primary key protects one database, not independently allocated IDs; globally coordinated or GUID-style keys are needed.
GUIDs can support disconnected generation but have wider keys and can increase fragmentation; tune clustering strategy.
Technical identity does not replace source lineage or natural-key rules needed to detect duplicate business records.