After last night's refresh, the ecommerce dashboard is showing every order three times, so the total revenue KPI has tripled. The visualization uses a live connection to the company's Snowflake data warehouse, and the ETL job's execution log reported no errors. No changes were published to the dashboard itself. Which action should the data analyst take first to determine whether the duplication originates in the visualization layer or in the warehouse?
Post a question to the BI vendor's community forum to ask about duplicate-row rendering defects.
Run a SQL query on the warehouse table to count rows per unique order ID and check for duplicates.
Clear the dashboard's cache and republish the workbook.
Increase the BI server's memory allocation to handle larger result sets.
Duplicated records can be introduced either in upstream tables (for example through an ETL load or an unexpected one-to-many join) or by the visualization layer's rendering logic. The quickest way to isolate the source is to validate the data at its source: run a direct SQL query against the fact table and count the rows (or distinct order IDs). If duplicates exist in the table, the problem is upstream; if the counts are correct in SQL but wrong in the dashboard, the issue is in the BI tool configuration. Clearing caches, tuning server memory, or opening a vendor ticket may be necessary later, but none of those steps establishes where the bad data appears, so they are not the appropriate first move.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Snowflake, and why is it used as a data warehouse?
Open an interactive chat with Bash
What is an ETL job, and how does it relate to data integrity?
Open an interactive chat with Bash
Why is running a SQL query the best way to check for data duplication?
Open an interactive chat with Bash
CompTIA Data+ DA0-002 (V2)
Data Analysis
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .