Correct Answer : Optimistic Locking in SQL Server using the ROWVERSION
Explanation : Implementing optimistic locking utilizing the row version data type is an effective, low overhead way to prevent lost updates while still maintaining application concurrency.