DBS-C01 · Question #176
A company is migrating an IBM Informix database to a Multi-AZ deployment of Amazon RDS for SQL Server with Always On Availability Groups (AGs). SQL Server Agent jobs on the Always On AG listener run a
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #176. The question stem and answer options stay visible for context.
Question
A company is migrating an IBM Informix database to a Multi-AZ deployment of Amazon RDS for SQL Server with Always On Availability Groups (AGs). SQL Server Agent jobs on the Always On AG listener run at 5-minute intervals to synchronize data between the Informix database and the SQL Server database. Users experience hours of stale data after a successful failover to the secondary node with minimal latency. What should a database specialist do to ensure that users see recent data after a failover?
Options
- ASet TTL to less than 30 seconds for cached DNS values on the Always On AG listener.
- BBreak up large transactions into multiple smaller transactions that complete in less than
- CSet the databases on the secondary node to read-only mode.
- DCreate the SQL Server Agent jobs on the secondary node from a script when the secondary node
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.