A company reports on seven years of data in a sales dashboard. The dashboard pulls from a sales database that has 30 years of data. The dashboard performance is slow. Which of the following is the…

Performing a code review might optimize existing queries, but it doesn't address the fundamental issue of processing excessive irrelevant data from the database.

Checking network connectivity addresses potential network bottlenecks, but it's less likely to be the primary cause of slowness if the dashboard is consistently slow due to large data pulls rather than intermittent connection issues.

When a dashboard's performance is slow and it pulls a small subset (7 years) from a much larger dataset (30 years), the most effective improvement is to filter the data at the source. Loading and processing only the necessary data reduces the volume transmitted and queried, significantly speeding up dashboard refresh and interaction.

Adding more RAM to the dashboard server or client might improve local processing, but it does not reduce the time spent fetching unnecessary data from the source database.