In this article, we will see the list of questions asked in EY Company Interview for 2+ year of experience candidate in big data field.

Let’s see the Questions:

1. What distinguishes wide transformations from narrow transformations in Spark?
2. How would you execute an anti join in Spark?
3. Could you describe what a semi join is in Spark?
4. What are the different types of anti joins?
5. How do cache and checkpoint differ in Spark?
6. What role does a DAG play in Spark?
7. How does speculative execution work in Spark?
8. Where is data stored when caching occurs in Spark?
9. What are the key components of Spark’s architecture?
10. Is it possible to uncache a DataFrame after caching it? How?
11. Why is it important to remove cached data in Spark?
12. What are the consequences of forgetting to uncache data in Spark? How does it impact performance?
13. What are RDDs in Spark?
14. In SQL, what is the specific purpose of window functions?
15. Can you explain the difference between ROLLUP and CUBE in SQL?
16. Which PySpark operator can you use to verify if two DataFrames are identical? What is a fast and specific function for this?
17. How does a CTE differ from a temporary table in SQL?

I hope these questions assist anyone preparing for their interviews.

Check out the given link for knowing about this company: EY
Check out the given link for knowing about this company rating on Glassdoor:  EY |GlassDoor

Check out the given link for this company profile on LinkedIn: LinkedIn

Thank you for reading this post.