How would you answer an interview scenario involving ExecuteUpdate and ExecuteDelete in Entity Framework Core?

For an interview scenario involving ExecuteUpdate and ExecuteDelete, I would first clarify the business goal, scale, constraints, and the failure or quality attribute the interviewer wants to explore. ExecuteUpdate and ExecuteDelete perform set-based modifications directly in the database without loading entities. In this scenario, you must expire 500,000 sessions nightly. Explain why a set-based update is preferable. For production, use set-based operations for suitable rules, validate filters carefully, and consider auditing and transaction boundaries. I would then explain the main alternatives and tradeoffs, identify likely failure modes, and describe how I would validate the solution through testing, observability, security controls, and recovery or rollback planning.