Specify the order of execution of operators in this SQL query.
Machine Learning / AI
Can we use the same metrics when measuring quality by top-K and the metric asked from the user (like/dislike)? Or are these different things?
Are you considering only the ML engineer position or also Data Scientist?
If we have tools or MCP — how does LLM invoke them?
What difficulties arise when using Word2Vec and NLTK for the Russian language?
The dialog table contains 80 million messages, and the analytical query for the assessment set takes 25 minutes and sometimes returns duplicate question-answer pairs. What would you fix first and why?
For question generation, a large language model poorly maintains style on rare topics. The AI assistant suggests immediately launching LoRA on the entire historical corpus of 2 million dialogues, but the annotation is partially noisy. Where would you not trust this advice and what would you choose first?
What is the difference between GET and POST requests?
In general, how does ChatGPT differ from an internal company assistant (chatbot vs. assistant)?
Tell about your projects: what exactly did you do personally, in detail technically?
What gradient boosting tools have you worked with? CatBoost, LightGBM, XGBoost?
How to approach aligning a single word by phonemes? How to use wav2vec2 to obtain accurate phoneme boundaries?
How to deal with the problem of increasing context when actively engaging in a dialogue with a user?
What are the main differences between machine learning and deep learning?
Why does structured output always produce valid JSON? At what level is this implemented?
How many features will you take from the feature store and how will you select them if all 5000 features are valid and without leaks?
What inspires you in your work?
What happens if you input a sequence of 10k tokens to a decoder, but the model was trained on 9k?
How are agents routed? Give an example of switching conditions.
What will happen to the model quality if the first and last trees are removed in a random forest and gradient boosting?