PrepAway - Latest Free Exam Questions & Answers

Which feature will enable you to specify a different backup schedule?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Partitioned View.

B.
Partitioned Table.

C.
FileTable.

D.
FileGroup.

Explanation:


Leave a Reply