LLD - Design — Hotel Booking System
A search system's filter on 'timestamp between start_date and end_date' returns unexpected results. Which of the following is the most probable cause?
A search system's filter on 'timestamp between start_date and end_date' returns unexpected results. Which of the following is the most probable cause?
medium📝 Analysis Q7 of 15
Step-by-Step Solution
Solution:
Step 1: Identify common date range issues
Timezone mismatches often cause unexpected filter results in date ranges.Step 2: Evaluate other options
Using inverted vs bitmap index or filter order usually doesn't cause date range errors; missing index would cause no results, not incorrect ones.Final Answer:
Incorrect timezone handling causing date mismatches -> Option AQuick Check:
Timezone errors affect date filters [OK]
Quick Trick: Check timezone conversions for date filters [OK]
Common Mistakes:
- Ignoring timezone differences
- Assuming filter order affects date range correctness
- Confusing index types with filter correctness
Master "Design — Hotel Booking System" in LLD
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore LLD Quizzes