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

1 day, 21 hours remaining!
Crucial Exams

CompTIA Data+ DA0-002 (V2) Practice Question

A BI analyst is troubleshooting a sales performance dashboard that connects to a cloud data-warehouse fact table containing five years (approx. 200 million rows) of row-level transactions. When business users open the dashboard, it regularly takes more than 60 seconds to load and returns incomplete totals because the warehouse kills any query that runs longer than 30 seconds. Stakeholders have confirmed they only need to see the current fiscal quarter's results during weekly meetings, and the analyst is not permitted to change the existing data model or measures. Which action that relies on data filtering will MOST effectively resolve both the long load time and the incomplete totals?

  • Replace the existing stacked bar charts with line charts to reduce rendering overhead

  • Add a data-source or SQL WHERE clause that restricts the dataset to the current fiscal quarter before the dashboard executes

  • Disable the index on the transaction_date column so the warehouse performs full-table scans

  • Export the dashboard as a static PDF and email it to stakeholders each week

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