DBS-C01 Question #176: Real Exam Question with Answer & Explanation

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

Explanation

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_SQLServerMultiAZ.html If you have SQL Server Agent jobs, recreate them on the secondary. You do so because these jobs are stored in the msdb database, and you can't replicate this database by using Database Mirroring (DBM) or Always On Availability Groups (AGs). Create the jobs first in the original primary, then fail over, and create the same jobs in the new primary.

No community discussion yet for this question.