Machine Learning / AI
What do you mean by an error (in the prompt approach)?
Why is normalization (Layer Norm) needed — why stabilize training?
X5 techHow were load peaks handled in the RAG system? What happened under high load?
How was the quality of the Text-to-SQL agent evaluated?
An agent never invokes one of the three tools. How to investigate and solve this problem?
What loss function did you use when fine-tuning the embedder?
X5 techWhat rank did you set for LoRA and what does it depend on?
What was actually more difficult than initially expected?
How to sort 20 chunks and select the top 5 most relevant for passing to LLM?
What are items? How is it correctly pronounced?
iviCan you tell us in more detail what exactly seemed 'stifling' to you in the questions and how it affected your perception of the interview?
How was the quality of generation evaluated (not retrieval)?
Tell about the forecasting task from your resume — what is the model built on and what was the prediction for?
WildberriesAre you familiar with GigaChat? Do you have experience working with it?
Tell us about yourself and your experience as a systems analyst
What is linear regression and what are the options for its solution?
X5 techWas the toolcalling native or through prompt (parsing)?
What is dropout and how does it work during training and inference?
AstonWhich companies are you currently at some stage with?
-- # -- Marketers launch promo campaigns in the app. There are two tables: -- # -- campaigns - list of campaigns -- # -- - campaign - campaign name -- # -- - action_type - campaign type: "push" or "banner" -- # -- communications - backend log of sending communications of these campaigns to users -- # -- - user_id - user identifier -- # -- - campaign - campaign name -- # -- - status - event status: "success" or "error" -- ------------------------------------------------------------------------------------------------------------------------ -- # -- 1. Initially, the campaigns table has 4 rows: -- # -- | campaign | action_type | -- # -- |-------------|-------------| -- # -- | promo_dogs | push | -- # -- | promo_cats | banner | <- randomly duplicated -- # -- | promo_cats | banner | <- two rows -- # -- | promo_rats | push | # # -- Also known that: -- # -- campaigns promo_dogs and promo_cats were successfully conducted on 100 users each, and each user received one communication, -- # -- while promo_rats is only planned. -- # -- 1.1 What will the query output: SELECT campaign, COUNT(*) as rows, COUNT(DISTINCT co.user_id) AS users FROM campaigns AS ca INNER JOIN communications AS co ON ca.campaign = co.campaign GROUP BY ca.campaign AS campaign -- # -- 1.2 How will the answer change if you change the JOIN type to LEFT? -- # -- 1.3 List the order of execution of the operators in this query. -- Answer: promo_dogs ... ...