A company reports on seven years of data in a sales dashboard.

This question falls under theData Governancedomain, focusing on optimizing data quality and performance in dashboards. The dashboard is slow because it pulls from a large database (30 years) but only needs seven years of data.

Performing a code review (Option A): A code review might identify inefficiencies, but it’s not the most direct solution for this scenario.

Checking network connectivity (Option B): Network issues might cause delays, but the primary issue is the data volume, not connectivity.

Filtering to include only relevant data (Option C): Filtering the data to include only the last seven years reduces the dataset size, directly improving performance by minimizing the data processed.

Adding more RAM and rerunning (Option D): Adding RAM might help, but it’s a hardware solution that doesn’t address the root cause of excessive data.

The DA0-002 Data Governance domain includes "data quality control concepts," such as optimizing performance by filtering data to improve efficiency.