You administer a Microsoft SQL Server 2012 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.
C.
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.
D.
Restore the latest full backup. Then, restore the latest differential backup.
E.
Restore the latest full backup. Then, restore each differential backup taken before the
time of failure from the most recent full backup.
F.
Perform a page restore.
G.
Perform a partial restore.
The answer for this question is only
Restore the latest fullbackup
There is neither log backup since reporting database is SIMPLE Recovery model nor differential backup since the question clearly mentioned differential backup failed.
2
0
Within B there is C restore full backup… Answers should go until H and C restore full is the only good answer
0
0
Correct answer : Restore the latest fulle backup
0
0
Correct Answer is : D
Check the sequence below..
1. Full Backup at: 01:00 HRS
2. Update from Transactional Database at 12:30 HRS
3. Differential Backup At: 13:00 HRS.
4. Reporting Database Crashed.
There are no changes at reporting server AFTER 12:30 HRS.
We have differential Backup of 13:00.
First Restore Full Backup + Differential Backup of 13:00.
0
0
Sorry, my above answer is wrong.
The Correct Answer is: Restore Full Backup, as Differential Backup fail..
0
0
This answer (c)is correct because if you restore only the Full Backup and the Diff Backup then you will lose all the data entered science the last diff backup till the last data entered
then you must also use the log backup in the period between two diff backup
Thanks
0
0
Sorry my above answer is wrong science there is no log backup in the simple mode
then It must be full backup then diff backup
0
0
also wrong cause theres no diff backup
1
0
To bring reporting database with minimum data loss, as to be in consistent with transactional database, here is sequence of events.
1. Reporting fails at 14:00
2. No reporting differential backup at 13:00
4. Reporting database is same as transactional database at 12:45, as it is updated at 12:30 and takes 15 minutes to be consistent with transactional database at 12:45. This means at 12:45 reporting database is same as transactional database.
5. So to bring reporting database as transactional database at 14:00 , restore transaction full backup from last night and then transactional differential backup at 14:00. So correct answer is D, if we want to bring reporting database as transactional database with minimum data loss.
0
0
I also think the correct answer is D. However the minimal data loss criterion would have to be sacrificed as the latest differential backup of reporting database failed. So it is only possible to take the differential backup the day before. No log backup will be generated as the recovery model is simple for the reporting database. I also do not think the backup logs can be used interchangeably between databases?
0
0
Sorry the answer should just be Restore the latest fullbackup since the diff backup failed. Some sites have more answers to choose.
0
0
Just another point. The question does not ask we are restoring reporting database at 14:00, it says it fails at 14:00. What if we restore database at say 15:00, then from this logic correct answer is C. We need to consider applying transactional log backups as well. Question does not ask to restore at 14:00, it says it fails at 14:00. So applying log backups makes good point. So C is best answer.
The point is making reporting as close to transactional database with minimum data loss.
0
0
Maddy,
question is whether we can use Transactional DB Logs for Reporting DB? The question doesn’t state how the Reporting DB is updated from Transactional DB. The logs might not be compatible?
0
0
What is the final answer for this? I’m thinking of B
0
0
other sites have more awnsers. e.g:
http://www.mcseanswers.com/latest-real-70-462-tests-dumps-and-vce-exam-questions-
31-40.html
in this case there is an additional awnser which is correct. restore the latest full back up
some one in the comments mentioned, in awnser B is the part with C the correct awnser but b is a full approach for backups in full recovery mode db’s
0
0
Restore the latest full backup.
0
0
b -> C Restore the latest full backup.
0
0
THOMAS IS RIGHT!
0
0
C is Wrong. simple model does not have log backups.
If there is a full then that is the answer if there is no full, the full + differential.
0
0
referring to the question 198 in the post, the good answer is:
A.Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
=> KO: No backup log in recovery simple
B.
Perform a point-in-time restore. C Restore the latest full backup.
=> KO: no point-in-time restore without logs, in recovery simple.
C.
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.
=> KO: no backup logs in recovery simple
D.
Restore the latest full backup. Then, restore the latest differential backup.
=> this is the good answer, even if there is no differential backup available.
E.
Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
=> only the last good differential is necessary.
F.
Perform a page restore.
=> Not applicable specification for a page restore.
G.
Perform a partial restore.
=> Not applicable
0
0