Exam 70-764 topic 1 question 35 discussion

Actual exam question from Microsoft's 70-764

Question #: 35
Topic #: 1

A Microsoft SQL Server database named DB1 has two filegroups named FG1 and FG2. You implement a backup strategy that creates backups for the filegroups.
DB1 experiences a failure. You must restore FG1 and then FG2.
You need to ensure that the database remains in the RECOVERING state until the restoration of FG2 completes. After the restoration of FG2 completes, the database must be online.
What should you specify when you run the recovery command?

A. the WITH NORECOVERY clause for FG1 and the WITH RECOVERY clause for FG2
B. the WITH RECOVERY clause for FG1 and the WITH RECOVERY clause for FG2
C. the WITH RECOVERY clause for both FG1 and FG2
D. the WITH NORECOVERY clause for both FG1 and FG2

Show Suggested Answer

Suggested Answer: A 🗳️

by cfdeangeliskro at Oct. 20, 2020, 5:31 p.m.

Comments

Submit Cancel

huzein

4 years, 7 months ago

No, it is said that must be first FG1 and then FG2. The DB remains is RECOVERY state until FG2 is restored completed, so B and C were eliminated. Since DB must be online after having restored FG2, answer D is eliminated. So A is correct.

upvoted 2 times

...

cfdeangeliskro

4 years, 7 months ago

Shouldn't this be the other way around? FG1 WITH RECOVERY and FG2 WITH NORECOVERY?

upvoted 1 times

...