Real questions from top companies
How do you clean missing values in a pandas DataFrame?
How do you install a Python library that is not in the Databricks runtime?
How do you sort a dictionary based on values?
How does your tech stack support scalability and analytics?
How many cities does each department operate in? List the top 3 departments in terms of the most number of cities. In case of a tie, order by dept_id.
How would you configure workload management (WLM) queues for heavy queries?
How would you decide between using DISTKEY and SORTKEY?
How would you handle errors in your code?
How would you handle memory constraints when processing a large dataset in Python?
How would you implement a program to determine the frequency of each letter in a string?
How would you process a 10TB dataset on a single machine in Python?
How would you test these functions with edge cases?
Identify the Unix command that lists files with specific permissions
Implement a Python function to count unique words from a file and write them to another file.
Implement a context manager class for a sequence generator using __enter__ and __exit__
Implement a function to find the maximum sum subarray (Kadane's algorithm).
Implement a function to reverse a string without using built-in methods.
Implement a generator function to yield Fibonacci numbers.
Implement a program to find the intersection of two lists.
Implement a program to remove duplicates from a list while maintaining order.
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.