Microsoft
70-432 · Question #144
70-432 Question #144: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #144. The question stem and answer options stay visible for context.
Question
Yon maintain a SQL Server 2008 instance that contains a database named Finance. The backup strategy for the Finance database specifies the following requirements: - Full database backup to a file named finance.bak is performed at 08:00 hours daily. - A transaction log backup to a file named finance_HHMM.trn is performed every 15 minutes starting at 08:15 horns. The Finance database is being used in single-user mode. At 08:40 hours, a user reports that some important data was accidentally deleted by a query that was executed at 08:23 horns. You need to restore the database to its original state. Which Transact-SQL statement(s) should you use?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 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.