You need to recommend a database reporting solution that meets the business requirements. What should you include in the recommendation?

Data Collection in SQL Server is a built-in framework that collects data from multiple sources, stores it in a management data warehouse, and provides pre-built reports on server activity, query performance, and resource usage. It is specifically designed to support ongoing database reporting requirements by capturing historical data at scheduled intervals, making it ideal for business reporting needs that require trend analysis and historical comparisons.

Performance Monitor (PerfMon) is a Windows OS-level tool for real-time counter monitoring and is not a SQL Server database reporting solution that persists and structures data for business reporting purposes.

A maintenance plan automates routine database maintenance tasks such as backups, index rebuilding, and integrity checks, but does not provide a reporting solution for database activity or performance data.

Dynamic Management Views (DMVs) provide real-time, in-memory snapshots of current server state and activity, but they do not persist historical data and are not a standalone reporting solution for ongoing business reporting requirements.