SQL Quiz
10 questions · no time limit
0:00
DATA QUALITY AND DEBUGGING
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
An inventory table stores periodic snapshots by
product_id, location_id, snapshot_ts, and quantity_on_hand. One report sums every snapshot recorded during a month. A finance report requests inventory on hand as of the month's closing time. Some product-location combinations do not receive a snapshot every day.Which approach best reconciles the inventory aggregate to the finance definition?
YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end