Ultimate access to all questions.
In a high-traffic data engineering environment, your team is managing a Delta Lake table that contains millions of rows and is frequently accessed by multiple concurrent users for both read and write operations. The organization prioritizes data consistency, performance, and scalability. Given these requirements, which of the following strategies would BEST ensure data consistency and prevent conflicts while maintaining high availability and performance? Choose the single best option.