Dspace Senior BI Engineer Interview Questions and Answers

Q1. Can you tell me about yourself?
Ans. 
I am a passionate software engineer with 5 years of experience in developing web applications using various technologies.
• 5 years of experience in software development

• Proficient in developing web applications

• Skilled in using various technologies

• Passionate about software engineering
Answered by AI
Add your answer
Q2. Can you explain one of the projects you completed during the academic year?
Ans. 
Developed a web-based student management system for tracking attendance and grades.
• Used HTML, CSS, and JavaScript for front-end development.

• Implemented backend functionality using PHP and MySQL database.

• Incorporated user authentication and authorization features for secure access.

• Tested the system thoroughly to ensure functionality and user-friendliness.
Answered by AI
Add your answer
Q3. What were some of the fundamental concepts of Artificial Intelligence that the interviewer inquired about during your interview as a Computer Science and Engineering - Artificial Intelligence and Machine L...read more
Add your answer
Q4. What were your Achievements in the graduation years
Ans. 
Graduated with honors, completed multiple internships, and won coding competitions
• Graduated with honors in Computer Science

• Completed internships at XYZ Company and ABC Corporation

• Won first place in coding competition at university hackathon
Answered by AI
Add your answer

Basic aptitudes question in online test

Two coding Q online test

Q1. Resume bsic Q asked
Add your answer
Q2. Oops question basic theory
Add your answer

Q1. One coding question asked to solve on paper of arrays
Add your answer
Q2. Basic questions from resume
Add your answer

Q1. Relocating related questions
Add your answer
Q2. Why u want to join global logic
Ans. 
I want to join Global Logic because of their reputation for cutting-edge technology solutions and collaborative work environment.
• Global Logic is known for their innovative technology solutions

• I am impressed by the collaborative work environment at Global Logic

• I believe Global Logic offers great opportunities for professional growth and development
Answered by AI
Add your answer

Q1. All type of joins with example
Ans. 
Different types of joins in SQL with examples
• 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 all rows when there is a match in either table
Answered by AI
Add your answer
Q2. How to handle large spark datasets
Ans. 
Large Spark datasets can be handled by partitioning, caching, optimizing transformations, and tuning resources.
• Partitioning data to distribute workload evenly across nodes

• Caching frequently accessed data to avoid recomputation

• Optimizing transformations to reduce unnecessary processing

• Tuning resources like memory allocation and parallelism for optimal performance
Answered by AI
Add your answer

Q1. How do you tune sparks configuration setting's to optimize query performance
Ans. 
Spark configuration settings can be tuned to optimize query performance by adjusting parameters like memory allocation, parallelism, and caching.
• Increase executor memory and cores to allow for more parallel processing

• Adjust shuffle partitions to optimize data shuffling during joins and aggregations

• Enable dynamic allocation to scale resources based on workload demands

• Utilize caching to store intermediate results and avo...read more
Answered by AI
Add your answer
Q2. What strategies do you use to handle data skew and partition imbalance in spark
Ans. 
To handle data skew and partition imbalance in Spark, strategies include using salting, bucketing, repartitioning, and optimizing join operations.
• Use salting to evenly distribute skewed keys across partitions

• Implement bucketing to pre-partition data based on a specific column

• Repartition data based on a specific key to balance partitions

• Optimize join operations by broadcasting small tables or using partitioning strategi
Answered by AI
Add your answer

Q1. How to create custom serializable interface
Ans. 
To create a custom serializable interface, you need to define an interface with the Serializable marker interface and implement the necessary methods.
• Define an interface with the Serializable marker interface

• Implement the necessary methods for serialization and deserialization

• Ensure all fields in the class implementing the interface are serializable
Answered by AI
Add your answer
Q2. Whatis criteria in hibernate
Ans. 
Criteria in Hibernate is used to create and execute dynamic queries.
• Criteria is an interface in Hibernate that allows the creation of dynamic queries without using HQL or SQL.

• Criteria queries are type-safe and can be easily modified at runtime.

• Criteria queries can be used to fetch entities based on certain conditions or restrictions.

• Example: Criteria criteria = session.createCriteria(Employee.class);
Answered by AI
Add your answer

Dominations of coins it was a dp question

Q1. Implement min stack
Ans. 
Implement a stack that supports finding the minimum element in constant time.
• Use two stacks - one to store the actual elements and another to store the minimum values at each level.

• When pushing an element, compare it with the current minimum and push the smaller value onto the minimum stack.

• When popping an element, also pop from the minimum stack if the popped element is the current minimum.
Answered by AI
Add your answer
Q2. Lca of given nodes in the tree
Ans. 
LCA (Lowest Common Ancestor) of given nodes in a tree is the node that is the lowest common ancestor of the given nodes.
• Traverse the tree to find the paths from the root to each of the given nodes.

• Compare the paths to find the last common node, which is the LCA.

• If one of the given nodes is the ancestor of the other, return the ancestor node as the LCA.
Answered by AI
Add your answer

Q1. They asked computer fundamental mcqs like OOPS,Database,pseusdocodes,sql.
Add your answer

The topic given to us was "Can AI replace human Intelligence?"

Q1. The round three was technical interview and they asked some technical questions and some were related to Resume.
Add your answer