Microsoft
70-451 · Question #28
70-451 Question #28: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #28. The question stem and answer options stay visible for context.
Question
You are a database developer. You develop solutions by using SQL Server 2008 in an enterprise environment. You are creating a SQL Agent job that uses Transact-SQL to update data in two related databases on two different servers. You have the following requirements: - The job can only execute once each evening. - The databases on each server use the full-recovery model. - Transaction log backups for the two databases occur at different times. - The job uses transactions to ensure that in the event of an error, all updates are rolled back. You need to ensure that when you restore a database on either server, the two databases are restored to a state that reflects the last time the job successfully executed. What should you do?
Options
- AEnsure both databases are altered using the NO_WAIT termination clause.
- BUse the Windows Sync Manager to ensure that the databases can never be out of
- CUse saved transactions.
- DUse marked transactions.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 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.