How would you answer an interview scenario involving connection resiliency and transient retries in Entity Framework Core?

For an interview scenario involving connection resiliency and transient retries, I would first clarify the business goal, scale, constraints, and the failure or quality attribute the interviewer wants to explore. EF Core providers can support retrying transient connection or command failures through execution strategies. In this scenario, an Azure SQL API sees intermittent transient failures. Explain how you would configure retries safely. For production, retry only transient errors, keep operations idempotent where possible, add observability, and avoid long-lived manual connections. 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.