Exam 70-764 topic 1 question 314 discussion

Actual exam question from Microsoft's 70-764

Question #: 314
Topic #: 1

DRAG DROP -
You administer a SQL Server instance. A database named DB1 is corrupted.
Backups of DB1 are available on a disk backup device located at Z:\Backups\Backup.bak. The backup device has the following backups sets:
✑ a full database backup that is the first backup set on the device (FILE = 1)
✑ a differential database backup that is the second backup set on the device (FILE = 2)
✑ a transaction log backup that is the third backup set on the device (FILE = 3)
You restore the full database backup and the differential database backup without rolling back the uncommitted transactions.
You need to restore the transaction log backup and ensure the database is ready for use after restoring the transaction log.
How should you complete the Transact-SQL statement? To answer, drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

Show Suggested Answer

Suggested Answer:

by msamm at Oct. 12, 2019, 4:44 p.m.

Comments

Submit Cancel

msamm

Highly Voted 5 years, 8 months ago

The correct answer is Restore Log, Recovery. It cannot be Restore Database because File = 3 is the Transaction log. Also the question specifies that the Transaction log is remaining to be restored and the database should be ready to use.

upvoted 13 times

...

maddy1989

Most Recent 4 years, 5 months ago

answer is Resotre Database.

upvoted 1 times

...

tapsAch

4 years, 9 months ago

RESTORE LOG is a correct answer RESTORE DATABASE AdventureWorks2012 FROM AdventureWorks2012_1 WITH NORECOVERY; GO RESTORE LOG AdventureWorks2012 FROM AdventureWorks2012_log WITH FILE = 1, WITH NORECOVERY; GO RESTORE DATABASE AdventureWorks2012 WITH RECOVERY; GO

upvoted 2 times

...