Kohli Media Interview Questions and Answers

Q1. Self introduction
Add your answer
Q2. Windows function and how you used
Ans. 
Window functions are used to perform calculations across a set of table rows that are related to the current row.
• Window functions are used in SQL to perform calculations on a specific subset of rows related to the current row.

• They are often used with aggregate functions like SUM, AVG, and COUNT to calculate running totals, moving averages, and rankings.

• Examples of window functions include ROW_NUMBER(), RANK(), LEAD(),
Answered by AI
Add your answer
Q3. Sql Coding questions. Window functions with joins.
Add your answer
Q4. Pyspark code for how you connect the data to ADLS with doing partition
Ans. 
Use PySpark code to connect data to ADLS with partitioning
• Use SparkSession to create a Spark application

• Set the configuration for ADLS storage account and container

• Read data from ADLS using Spark DataFrame API

• Partition the data based on a specific column while writing back to ADLS
Answered by AI
Add your answer

Q1. Tell about yourself
Add your answer
Q2. About your experience
Add your answer

Q1. How you handle the escalation
Add your answer

Q1. Salary discussion
Add your answer

Q1. DC DC power supply and their details
Add your answer
Q2. Inductor and common mode choke parameters and usage
Add your answer

Q1. Technically experience skill
Add your answer
Q2. Integration Testing
Add your answer

Q1. Company Experience
Add your answer
Q2. Salary
Add your answer

PEN PAPER round consisting of three coding and c/c++ output based questions.

Q1. OOPS concepts , javascript
Add your answer
Q2. Projects related questions
Add your answer

Q1. Behavioural questions
Add your answer
Q2. Resume , internship related questions
Add your answer

Q1. Total experience
Add your answer
Q2. How will you update client on regular basis?
Ans. 
I will update clients through regular progress reports, meetings, emails, and phone calls.
• Provide regular progress reports detailing project status and milestones

• Schedule regular meetings to discuss project updates and address any concerns

• Send frequent emails with updates on project progress and next steps

• Communicate via phone calls to provide immediate updates or address urgent issues
Answered by AI
Add your answer

Question based on dsa

Q1. General questions
Add your answer

Setup a cluster and find the bottleneck of performance.

Q1. Ways to deal with latency in Cassandra
Ans. 
Ways to optimize latency in Cassandra
• Use appropriate data modeling to reduce the number of queries needed

• Optimize queries by using appropriate indexes and clustering keys

• Tune the Cassandra configuration settings for better performance

• Use caching mechanisms like Memcached or Redis to reduce latency

• Consider using partitioning strategies to distribute data evenly across nodes
Answered by AI
Add your answer