フリー問題

問題文

Two reports disagree on the number of active customers for the same month. Both read the same table. What is the first thing to compare?

選択肢

1. The clustering state of the table and the clustering depth, because poor clustering can cause rows to be skipped during pruning.
2. Whether one report used the result cache, because cached results can be stale relative to the table.
3. The warehouse each report runs on and the cache it uses, because a smaller warehouse can return incomplete results under load.
4. The definition each report uses for active and for the month boundary, including the time zone applied to the timestamp.