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
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