hard20 pts · first answer countsdata-modellingtime-zones

Date key for a late-night Dubai order

Events are stored in UTC. A Dubai store (UTC+4) takes an order at 21:30 UTC on 31 March. Daily store reports follow the local business day. Which date key should the fact get?

A.31 March, because the stored time is UTCB.Either date, as long as it is consistentC.1 April, the local date, keeping the UTC time tooD.No date key until the time zone is removed

Discussion 0

Join free to post in the discussion.

Date key for a late-night Dubai order

Discussion 0

Related questions