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
A fact table contains 1,0001{,}000 rows. Of these, 2020 have no matching dimension key. The dimension normally contains one row per key, but key K appears three times. Exactly 1515 fact rows reference K.
What row count should an inner join from the fact table to the dimension table produce?
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