Tell us what you know about Apache Kafka. What does a topic consist of?
Data Analyst
What is a p-value and how to draw conclusions from it when analyzing an A/B test (rejecting or not rejecting the null hypothesis)?
What is PERCENTILE_CONT and what does it return?
Do you have experience in financial or operational modeling?
-- Find the top 5% users with the highest number of orders by name.
What are other ways to solve the problem of finding employees older than the manager? (alternative approaches)
Why is LEFT JOIN used instead of other types of JOIN?
Explain the algorithm for computing the dot product of two compressed (RLE-encoded) vectors in a single pass without unpacking them. What is the asymptotic time complexity?
How can you speed up solving problems if the alphabet consists only of lowercase Latin letters?
How to conduct A/B tests?
Tell me more about your course project: what kind of bot it is, what functionality, what features were included in the model?
What challenges do you face when preparing for interviews? (повторный вопрос с просьбой развернуть ответ)
Has ML been used for feature selection in a car classification task?
What do you usually do after the SQL for a DBT model is ready?
// we have a method to get product information, this method is called very often // are there any problems with this code and how to fix it? PostgreSQL database
Tell me about yourself and your work experience
Tell us about your most interesting projects and why you want to develop in analytics
Describe your career path and specialization (question from the instructor about the department and specialization)
How does electronic digital signature (EDS) work?
class SparseVector: def __init__(self, nums: list[int]): def dotProduct(self, vec: 'SparseVector') -> int: