Sobes.tech

Data Analyst

Can you give a specific example when you found something and told the business, and they were engaged/reacted?

148

Will the stock returns be normally distributed? (minute-by-minute price increases from 2000 to 2026)?

148

В чем разница между оконными функциями ROW_NUMBER, RANK и DENSE_RANK?

Middle
147

What is the memory complexity of the Product of Array Except Self problem and what additional variables are used?

147

Do you have any questions for the interviewer?

147

Tell me about yourself: who are you, what do you do, and what are your hobbies?

146

Presented are tables A and B: select * from A +----+-----+ |id |val | +----+-----+ |1 |A | |2 |B | |3 |C | +----+-----+ select * from B +----+-----+ |id |val | +----+-----+ |1 |A | |2 |B | |3 |C | |4 |A | +----+-----+ Will the results returned by the following queries differ? 1 select * from A left join B on A.id = B.id and B.val = 'A' 2 select * from A left join B on A.id = B.id where B.val = 'A'

Middle
146

How did you verify data and understand that you can trust it? Was there any algorithm?

146

What integrations have you implemented and what exactly did you do? (Kafka, REST, RabbitMQ, synchronous/asynchronous)

Middle
146

What projects are you interested in — only technical or do you consider consulting? What do you want to develop?

146

What is the difference between the DROP and TRUNCATE commands?

146

When are you ready to start working if all stages are successfully passed? Are there planned vacations?

145

Write a complete sum_series function in Python and test it with an example from the task.

145

Tell me about the ETL process. What do you know about it?

145

Where in real life does the normal distribution occur, and where does it not? Provide specific examples with explanations why data is normally distributed or not.

145

How would you create a geometry benchmark? Describe the chain from idea to final dataset.

145

What are the most common errors encountered in BI? Which ones have you faced?

144
/15