⚡️ Pass with Confidence Sale - 40% off ALL packages! ⚡️

1 day, 17 hours remaining!
Crucial Exams

CompTIA Data+ DA0-002 (V2) Practice Question

Your company's sales dashboard uses a live connection to a SQL Server data warehouse. End-users report that each time they change the fiscal-quarter filter the visuals take almost two minutes to refresh, even though CPU and memory usage on the BI server stay low and the dataset is only 50 MB. Before you try to tune the data model or adjust gateway settings, which troubleshooting action will most directly reveal whether the latency is coming from the database layer or from the report's rendering layer?

  • Export the report data to CSV, compress it, and import the file back into a new dataset before refreshing.

  • Delete and recreate all visuals in the report to clear any cached metadata.

  • Increase the dashboard's auto-refresh interval from every 5 minutes to every 60 minutes to reduce server load.

  • Run the dashboard's underlying SQL query directly against the database and record its execution time.

CompTIA Data+ DA0-002 (V2)
Visualization and Reporting
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot