Draup Interview Questions and Answers

Swap consecutive values in an array of strings

• Iterate through the array and swap each pair of consecutive values

• Use a temporary variable to hold one value while swapping

• Ensure to handle cases where the array has an odd number of elements

Find employees earning more than their managers using SQL queries.

• Use a self-join on the employee table to compare salaries.

• Example SQL: SELECT e1.name FROM employees e1 JOIN employees e2 ON e1.manager_id = e2.id WHERE e1.salary > e2.salary;

• Ensure the employee and manager relationship is correctly defined in the table.

Understanding PySpark window functions for data analysis and manipulation.

• Window functions allow you to perform calculations across a set of rows related to the current row.

• Example: Calculate a running total using 'sum' over a specified window.

• Syntax: from pyspark.sql import Window; windowSpec = Window.partitionBy('column_name').orderBy('another_column')

• Use 'row_number()', 'rank()', and 'dense_rank()' to assign un...read more

Primary research involves collecting data firsthand, while secondary research involves using existing data.

• Primary research is conducted by the researcher themselves, such as surveys, interviews, and experiments.

• Secondary research involves analyzing data that has already been collected by others, such as books, articles, and databases.

• Primary research is more time-consuming and expensive but provides specific and ...read more

The count of airplanes that go in and out of Bangalore airport in a day can vary depending on factors like day of the week, time of day, and season.

• Consider the average number of flights per hour and multiply by the operating hours of the airport

• Factor in peak travel times and additional flights for special events or holidays

• Consult airport statistics or flight tracking data for a more accurate estimate

I am proficient in MS Office, including Excel for data analysis, Power BI for visualization, Teams for collaboration, and Outlook for communication.

• Excel: Advanced functions like VLOOKUP, pivot tables for data analysis.

• Power BI: Creating interactive dashboards to visualize data trends.

• Teams: Facilitating team collaboration through chat, video calls, and file sharing.

• Outlook: Managing emails, calendars, and tasks e...read more