Hotel Barak Residency Front Office/Guest Relations Executive/Manager Interview Questions and Answers

Q1. I was asked to write code and some scenario based question on Big Data etc
Add your answer

2nd with VP which is easy but he seems not okay with my ECTC

Q1. General Data Warehousing questions like explain your pipeline, how you implemented scd2?
Add your answer
Q2. SQL questions like increment top 5th salary by 10k, last day of month, etc.
Add your answer

Q1. Project question like how connected to s3 bucket through pyspark,HDFS basic commands likhe copy etc ,how and where created hive table (if used in your project).
Add your answer
Q2. Share variables in pyspark like broadcast and accumulator..(i will suggest go through pyspark official documentation once)
Add your answer
Q3. Sql joins- , how to read file in pyspark, job scheduling means resource allocation within and across spark..(ans- can go through job scheduling of pyspark documentaion )
Add your answer

Basic aptitude test asking questions very basic

Coding questions based on dsa

Q1. Basic hr question
Add your answer

Q1. Mostly on cloud tools
Add your answer

Q1. Architecture of Spark
Ans. 
Spark is a distributed computing system that provides an interface for programming clusters with implicit data parallelism.
• Spark is built on the concept of Resilient Distributed Datasets (RDDs), which are fault-tolerant collections of objects.

• It supports various programming languages such as Scala, Java, Python, and R.

• Spark provides high-level APIs for distributed data processing, including transformations and actions.

• ...read more
Answered by AI
Add your answer
Q2. What is Lazy evaluation in spark
Ans. 
Lazy evaluation is a strategy used by Spark to delay the execution of transformations until an action is called.
• Lazy evaluation improves performance by optimizing the execution plan

• Transformations in Spark are not executed immediately, but rather recorded as a lineage graph

• Actions trigger the execution of the transformations and produce a result

• Lazy evaluation allows Spark to optimize the execution plan by combining an...read more
Answered by AI
Add your answer
Q3. Difference between Left join and inner join
Ans. 
Left join returns all records from the left table and the matching records from the right table.
• Inner join returns only the matching records from both tables.

• Left join includes all records from the left table, even if there are no matches in the right table.

• Inner join excludes the non-matching records from both tables.

• Left join is used to retrieve all records from one table and the matching records from another table.

• I...read more
Answered by AI
Add your answer

Q1. General questions about data engineering
Add your answer

Q1. General question on data topics and cloud
Add your answer

Q1. Salary and location
Add your answer

Q1. Self Introduction
Add your answer
Q2. About the current project
Add your answer
Q3. Different types of joins in SQL
Ans. 
Different types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables.

• Left join: Returns all rows from the left table and the matched rows from the right table.

• Right join: Returns all rows from the right table and the matched rows from the left table.

• Full outer join: Returns rows when there is a match in either table.
Answered by AI
Add your answer
Q4. Questions related to Cloud
Add your answer

Q1. Roles and responsibilities in current project
Add your answer
Q2. Optimizations used in present project
Ans. 
Various optimizations such as indexing, caching, and parallel processing were used in the project.
• Implemented indexing on frequently queried columns to improve query performance

• Utilized caching mechanisms to store frequently accessed data and reduce database load

• Implemented parallel processing to speed up data processing tasks

• Optimized algorithms and data structures for efficient data retrieval and manipulation
Answered by AI
Add your answer
Q3. How did you overcome out of memory issues
Ans. 
I optimized code, increased memory allocation, used efficient data structures, and implemented data partitioning.
• Optimized code by identifying and fixing memory leaks

• Increased memory allocation for the application

• Used efficient data structures like arrays, hashmaps, and trees

• Implemented data partitioning to distribute data across multiple nodes
Answered by AI
Add your answer