What should you include in the recommendation?

You need to recommend a solution that addresses the backup issue. The solution must minimize the amount of development effort.

What should you include in the recommendation?
A . Indexed views
B . Filegroups
C . Table partitioning
D . Indexes

View Answer

Answer: B

Explanation:

* Backup Issues

Customers who have large amounts of historical purchase order data report that backup time is unacceptable.

* For very large databases (and by that, I mean, at least 500gb, but more like 5-10tb or more), it can become too expensive to regularly run a straight full backup . So, where needed, you can choose to backup smaller pieces of the database by choosing to back up one of the files or file groups that make up a database.

Reference: Using Filegroups and Files to Store Data