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.
Within B there is C restore full backup… Answers should go until H and C restore full is the only good answer
Correct answer : Restore the latest fulle backup
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.
Sorry, my above answer is wrong.
The Correct Answer is: Restore Full Backup, as Differential Backup fail..
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
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
also wrong cause theres no diff backup
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.
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?
Sorry the answer should just be Restore the latest fullbackup since the diff backup failed. Some sites have more answers to choose.
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.
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?
What is the final answer for this? I’m thinking of B
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
Restore the latest full backup.
b -> C Restore the latest full backup.
THOMAS IS RIGHT!
Option H is missing. It should be full backup restore. check out the below links. same question has been answered.
http://www.mcseanswers.com/latest-mcse-70-462-real-exam-download-51-60.html
http://www.aiopass4sure.com/microsoft-exams/70-462-exam-questions/you-need-to-ensure-that-the-reporting-database-is-restored.html
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.
New 70-462 Exam Questions and Answers Updated Recently:
NEW QUESTION 198
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:
image: examgod.com/plimages/0ec7c271419f_F81C/1981_thumb5_thumb.jpg
One of the hard disk drives that stores the reporting database fails at 23:32 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. Perform a page restore.
B. Perform a partial restore.
C. Perform a point-in-time restore.
D. Restore the latest full backup.
E. Restore the latest full backup. Then, restore the latest differential backup.
F. Restore the latest full backup, and restore the latest differential backup. Then, restore the latest log backup.
G. 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.
H. Restore the latest full backup. Then, restore each differential backup taken before the time of failure from the most recent full backup.
Answer: E
Explanation:
To recover the database, you must restore the latest full backup and then restore the latest differential backup.
Incorrect answers:
A: A page restore is used to repair isolated damaged pages. It is faster than a file restore id only a few individual pages are damaged.
B: Partial restores allow a database that contains multiple filegroups to be restored and recovered in stages.
It works with all recovery models, but is more flexible for the full and bulk-logged models than for the simple model.
C: Point in time restores are not supported for the simple backup model as log files are not part of the backup.
D: The latest full backup was performed at 01:00 hours, 22 hours and 32 minutes before the hard disk failure. A differential backup was made at 13:00 hours, 10 hours and 32 minutes before the hard disk failure. A differential backup contains data that has been added or updated since the last full backup and should be restored to minimize data loss.
F, G: There is not log backup in the simple backup model.
H: Only the latest differential backup needs to be restored.
NEW QUESTION 199
Drag and Drop Question
You administer a Microsoft SQL Server 2012 database named Human_Resources. You need to ensure that all read activity against any object in the Human_Resources database is audited and written to a text file. What should you do? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
image: examgod.com/plimages/0ec7c271419f_F81C/1991_thumb4_thumb.jpg
Answer:
image: examgod.com/plimages/0ec7c271419f_F81C/1992_thumb4_thumb.jpg
Explanation:
The general process for creating and using an audit is as follows.
1. Create an audit and define the target.
2. Create either a server audit specification or database audit specification that maps to the audit. Enable the audit specification.
3. Enable the audit.
4. Read the audit events by using the Windows Event Viewer, Log File Viewer, or the fn_get_audit_file function.
NEW QUESTION 200
You administer a Microsoft SQL Server 2012 Enterprise Edition server that uses 64 cores. You discover performance issues when complex calculations are performed on large amounts of data under heavy system load. You need to limit the number of cores that process the calculations. What should you configure?
A. Max worker threads
B. Processor affinity
C. I/O affinity
D. Lightweight pooling
Answer: B
Explanation:
To carry out multitasking, the operating system sometimes moves process threads among different processors. This is efficient from an operating system point of view, but can reduce SQL Server performance under heavy system loads, as each processor cache is repeatedly reloaded with data. Assigning processors to specific threads can improve performance under these conditions by eliminating processor reloads; such an association between a thread and a processor is called processor affinity.
NEW QUESTION 201
……
NEW QUESTION 203
Which of the following conditions must exist prior to restoring a system database in SQL Server 2012?
A. The hard drive must be reformatted.
B. You must detach the user databases from the SQL 2012 instance.
C. The SQL Server 2012 instance must be started in single-user mode.
D. The SQL Server 2012 instance must be removed.
Answer: C
NEW QUESTION 204
Which of the following is the default instance name in an SQL Server 2012 installation?
A. SQLSERVER12
B. MSSQLSERVER
C. MSSQL
D. 2012SQL
Answer: B
NEW QUESTION 205
In which of the following statements about audit information stored in an SQL Server 2012 environment is TRUE?
A. It is located in a file specified in the File Path property of the Audit.
B. It is located in the Audit table in the MSDB database.
C. Each login has an audit record, which is viewable under Logins -> Audit.
D. SQL 2012 does not store any audit information.
Answer: A
NEW QUESTION 206
……
P.S. These New 70-462 Exam Questions Were Updated By PassLeader, You Can Get The Newest 70-462 Dumps In PDF And VCE From — https://tr.im/V0jkC (243q dumps)
Good Luck !!!
Hi Gonzalez,
I scanned the PassLeader questions, and I notice that there are some 461 questions about inner joins or views. Can you or someone else confirm, that these questions will be asked at the exam? It’s a bit confusing.
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