Exam 70-764 topic 1 question 65 discussion

Actual exam question from Microsoft's 70-764

Question #: 65
Topic #: 1

You administer a Microsoft SQL Server 2016 server that hosts a transactional database and a reporting database.
The transactional database is updated through a web application and is operational throughout the day.
The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table:

The differential backup of the reporting database fails.
Then, the reporting database fails at 14:00 hours.
You need to ensure that the reporting database is restored.
You also need to ensure that data loss is minimal.
What should you do?

A. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
B. Perform a point-in-time restore.
C. Restore the latest full backup.
D. Restore the latest full backup, and restore the latest differential backup. Then, restore each log backup taken before the time of failure from the most recent differential backup.
E. Restore the latest full backup. Then, restore the latest differential backup.
F. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
G. Perform a page restore.
H. Perform a partial restore.

Show Suggested Answer

Suggested Answer: C 🗳️
The differential backup of the reporting database has failed, so it can't be used.

by Guest at Nov. 25, 2019, 2:17 p.m.

Comments

Submit Cancel

jolsca

4 years, 9 months ago

Correct is C as the DB fails at 14:00 and I have the full backup: 01:00. Also I did not lose data since the changes occur from 00:30 and 12:30

upvoted 1 times

...

TheSwedishGuy

5 years, 4 months ago

The question has wrong info, says the database failed at 14:00, but it should be failed at 13:00.

upvoted 1 times

...

TheSwedishGuy

5 years, 4 months ago

Since the diff backup failed at 13:00, the latest available backup is from 01:00, which turns out to be the full backup.

upvoted 2 times

...

Guest

5 years, 6 months ago

Sorry, ignore my comment, missed a line...

upvoted 1 times

...

Guest

5 years, 6 months ago

There is no reason why the diiferential backup at 13:00 is failed Even simple recovery mode allows differential backups (but no transaction log backups) See https://www.mssqltips.com/sqlservertutorial/9/sql-server-differential-backups/ So I'd select E.

upvoted 2 times

...