You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the Piecemeal restore strategy.
Which of the following is TRUE with regards to this strategy? (Choose all that apply.)
A.
It restores a file or filegroup in a multi-filegroup database.
B.
It restores individual pages.
C.
It restores the database in stages, starting with the primary filegroup and one or more
secondary filegroups.
D.
It recovers data that is already consistent with the database and needs only to be made
available.
Explanation: