Sample questions from the Design and Implement Data Storage section
Let's look at a random mix of questions from data storage-related topics.
Case study – data lake
The case study questions will have a detailed description of the case followed by the questions.
Background
You have been hired to build a ticket scanning system for a country's railways department. Millions of passengers will be traveling on the trains every day. It has been observed that some passengers misuse their tickets by sharing them with others or using them for more rides than allowed. The railway officers want a real-time system to track such fraud occurrences.
Technical details
- A ticket is considered fraudulent it if is used more than 10 times a day.
- Build a real-time alerting system to generate alerts whenever such fraud happens.
- Generate a monthly fraud report of the number of incidents and the train stations where it happens.
You need to build a data...