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?

Indexed views are precomputed result sets stored as physical data used to improve query performance, and they have no direct capability to address backup or restore challenges.

Filegroups allow a database to be divided into separate storage units, enabling partial or piecemeal backups and restores at the filegroup level. This means you can back up only the filegroups containing critical or frequently changing data, reducing backup windows and recovery times. Implementing filegroups requires configuration changes rather than application code changes, minimizing development effort.

Table partitioning divides large tables into smaller segments for manageability and performance, but it does not directly provide a mechanism for selective or optimized backups without additional configuration and development work.

Indexes are data structures that improve query performance by enabling faster data retrieval, and they have no functionality related to backup strategies or resolving backup issues.