hard20 pts · first answer countsdata-qualitysql

Daily numbers do not match

Your dashboard shows 4,812 orders for 1 March, but the operations team in India reports 5,090. Data is stored in UTC. What is the most likely cause?

A.The BI tool caches old dataB.Duplicate rows in the operations systemC.COUNT(DISTINCT) is approximate in the warehouseD.Your day boundary is UTC midnight while operations use IST (UTC+5:30), so the two "days" cover different hours

← Only looking at active customers A metric that can be gamed →