You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
The company has a database named CorpDB1.
CorpDB1 is over 1 Terabyte in size and contains many tables.
The backup schedule for CorpDB1 includes a full backup every week, a differential backup every
day and a transaction log backup every hour.
You plan to add a table to CorpDB1. You want the new table to have a full backup every night and
a transaction log backup every 15 minutes.
Which feature will enable you to specify a different backup schedule?
A.
Partitioned View.
B.
Partitioned Table.
C.
FileTable.
D.
FileGroup.
Explanation: