An application needs a connection string that changes when the database password rotates, with zero downtime. What design achieves this?
- A Hardcode the password
- B Store the connection string in Key Vault, rotate with dual credentials, and refresh the client cache on the rotation event (correct answer)
- C Restart the app hourly
- D Disable rotation
Shortcut: Two-set credential rotation keeps the old credential valid while the new one is published, and refreshing the cache on the rotation event avoids any window of failed authentication.