Z1 Tech Data Analyst Interview Questions and Answers

Q1. 1. First question was, from my project asked me that explain one project.
Ans. I have done three project, out of this three project one project was movie recommendation syatem. That i was explained. Then some counter question from project like how did you convert text to numerical, which technique you used here. I able to give all questions answer from project.
Answered by adventurouseggnog
Add your answer
Q2. 2. After they asked me, what is your subject preference?
Ans. My subject preference was NLP, Deep Learning, ML. Afrer that asked some question from NLP like what is term document matrix, tf-idf, word embedding, Gradient descent, why we have to change learning rate after every epoch, how lr change, precision recall.
Answered by adventurouseggnog
Add your answer
Q3. 3. My one projcet was sentimental analysis that was by LSTM model. So, next question was explain how LSTM model work and architecture .
Ans. Then I was explained workin flow of LST model and architecture. Then asked me did you know bidireectional LSTM. I said yes, then explained.
Answered by adventurouseggnog
Add your answer
Q4. 4. One question was from sql. what is the condition for primary key? last question one case business case study. this is all about my interview. My interview was 50 min and selected for HR round.
Add your answer

Q1. Phone call round, just asked me are you interested to come here.
Add your answer

Q1. Kubernetes and Docker
Add your answer

Leetcode hard level coding with 4-5 questions

Q1. Machine Learning algorithms, Statistics, NLP
Add your answer

Q1. Write a SQL query to find all duplicate emails in a table named person
Ans. 
SQL query to find duplicate emails in a table named person
• Use GROUP BY and HAVING clause to group emails and count their occurrences

• Select only those emails which have count greater than 1

• Example: SELECT email, COUNT(*) FROM person GROUP BY email HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q2. Given a weather table, write a sql query to find all date's ids with higher temperature compared to it's previous dates
Ans. 
SQL query to find date ids with higher temperature compared to previous dates in weather table
• Use self join to compare temperature of current date with previous dates

• Order the table by date to ensure correct comparison

• Select date ids where temperature is higher than previous dates
Answered by AI
Add your answer