UPAI Interview Questions and Answers

Q1. End to end architecture of current project
Add your answer
Q2. Basic spark code to read & write files
Add your answer
Q3. How to upsert data in table in spark
Add your answer
Q4. How do you handle sudden increase in data volume
Add your answer
Q5. Discussion on delta tables & ACID transactions
Add your answer
Q6. Explain autoloader and use case in Databricks
Add your answer
Q7. SQL question using window functions Lead, row number
Add your answer
Q8. Python question using hashmap & String
Add your answer

Q1. Current project understanding end to end
Add your answer
Q2. Data pipeline design for a ride sharing company, ask bunch of follow up questions on the conclude a particular design.
Add your answer
Q3. Explain how you follow SDLC(Agile, waterfall) ?
Add your answer
Q4. Why are you looking for a change now
Add your answer

Q1. Basic introductions
Add your answer
Q2. What kind of work are you looking for? what do you know about the company
Add your answer
Q3. Willing to relocate?
Add your answer
Q4. Personal hobbies and aspirations
Add your answer

It was conducted in hacker earth
Around 1:55hr

Q1. Write a code for encrypting and decryption of character
Ans. 
Code for encrypting and decrypting characters using a simple algorithm
• Use a simple algorithm like shifting the characters by a fixed number of positions in the ASCII table

• For encryption, add the fixed number to the ASCII value of each character

• For decryption, subtract the fixed number from the ASCII value of each character
Answered by AI
Add your answer
Q2. Given a python code find the bugs
Ans. 
Identify bugs in a given Python code
• Check for syntax errors such as missing colons or parentheses

• Look for logical errors in the code that may cause unexpected behavior

• Test edge cases and boundary conditions to ensure code handles all scenarios

• Use debugging tools like print statements or a debugger to trace the flow of the code
Answered by AI
Add your answer

2 DSA Questions, medium level

Q1. System Design for a application
Add your answer

Q1. High Level System Design
Add your answer

Q1. About yourself ?
Add your answer
Q2. Just asked questions on previous role
Add your answer
Q3. How many types of IOT devices are there
Ans. 
There are three main types of IoT devices: consumer, commercial, and industrial.
• Consumer IoT devices: Smart home devices like thermostats, lights, and security cameras.

• Commercial IoT devices: Smart meters, asset tracking systems, and connected vending machines.

• Industrial IoT devices: Sensors and actuators used in manufacturing, agriculture, and healthcare.
Answered by AI
Add your answer

Q1. Self introduction
Add your answer
Q2. Technical questions
Add your answer

Q1. Technical questions
Add your answer
Q2. Technical questions
Add your answer

Q1. Behavioural questions
Add your answer
Q2. Work environment
Add your answer

Q1. Generate a Dataframe
Add your answer

Q1. About past intern experience
Add your answer
Q2. Product improvement question
Add your answer

Weather dashboard app

Js coding test on array and loops