Micron Technology Data Engineer Interview Questions and Answers

Q1. Very Easy sql questions
Add your answer
Q2. Very eeasy basic python question
Add your answer
Q3. Arey bhai access karne de
Add your answer

Q1. Pyspark questions on syntax
Add your answer
Q2. Repartition and coalesce difference
Ans. 
Repartition increases or decreases the number of partitions in a DataFrame, while coalesce only decreases the number of partitions.
• Repartition involves shuffling data across the network, while coalesce tries to minimize shuffling by only creating new partitions if necessary.

• Repartition is typically used when increasing the number of partitions for parallelism, while coalesce is used when decreasing partitions to optimi...read more
Answered by AI
Add your answer

Pyspark, python, sql

30 MCQ asked in Big Data

Q1. Simple sql question on group by clause, simple coding question ,
Add your answer
Q2. Finding kth largest element in array
Ans. 
Finding kth largest element in array
• Sort the array in descending order and return the element at index k-1

• Use a max heap to find the kth largest element

• Implement quickselect algorithm to find the kth largest element
Answered by AI
Add your answer

Q1. Basic questions.
Add your answer
Q2. What you will do with huge volume of data.
Ans. 
I will use various techniques like data preprocessing, storage optimization, and distributed computing to handle and analyze the huge volume of data.
• Implement data preprocessing techniques like data cleaning, data transformation, and data integration to ensure data quality.

• Utilize storage optimization techniques like data compression and partitioning to efficiently store and retrieve large volumes of data.

• Leverage dist...read more
Answered by AI
Add your answer