Comcast India Engineering Center Engineer Interview Questions and Answers

Fancy string problem

Q1. You are given 2 tables, customer and orders, you have to write an SQL query to fetch the total order placed by each customer and also give the total order amount.
Add your answer
Q2. Java Streams question to find the total number of employees that have salary greater than 50000
Ans. 
Use Java Streams to find total employees with salary > 50000
• Filter employees with salary > 50000 using stream.filter()

• Count the number of employees using stream.count()
Answered by AI
Add your answer
Q3. The various annotations used in Springboot @Entity, @RestController etc
Ans. 
Annotations in Springboot like @Entity, @RestController are used for defining classes and endpoints respectively.
• Annotations like @Entity are used to define JPA entities in Springboot.

• Annotations like @RestController are used to define RESTful web services endpoints.

• Annotations like @Autowired are used for dependency injection in Springboot.
Answered by AI
Add your answer
Q4. AWS services used in my previous project
Ans. 
In my previous project, I used AWS services such as EC2, S3, and RDS for hosting, storage, and database management.
• EC2 for hosting application servers

• S3 for storing and retrieving files

• RDS for managing relational databases
Answered by AI
Add your answer

Q1. All questions were asked based on my resume. So prepare well from your resume.
Add your answer

Q1. 4th round was a one on one with the manager, asked me general questions about why I was looking for a job change.
Add your answer

Q1. Basic datawarehousing concepts
Add your answer
Q2. Powerbi questions basic ones
Add your answer

Q1. Basic qns were asked related to process
Add your answer

Q1. Direct one to one discussion
Add your answer

Q1. How to handle security in Kafka?
Ans. 
Security in Kafka can be handled through authentication, authorization, encryption, and SSL/TLS.
• Implement authentication mechanisms like SASL or SSL for secure communication between clients and brokers.

• Set up ACLs (Access Control Lists) to control access to topics and resources.

• Enable encryption using SSL/TLS to secure data in transit.

• Use tools like Confluent Security Plugins for additional security features.

• Regularly ...read more
Answered by AI
Add your answer
Q2. Benefits of Microservices?
Ans. 
Microservices offer benefits such as scalability, flexibility, resilience, and easier maintenance.
• Scalability: Microservices allow for individual components to be scaled independently, leading to better resource utilization.

• Flexibility: Each microservice can be developed, deployed, and updated independently, allowing for more flexibility in the development process.

• Resilience: If one microservice fails, it does not brin...read more
Answered by AI
Add your answer
Q3. Have you done any customisation in spring-boot?
Ans. 
Yes, I have done customisation in spring-boot.
• Implemented custom error handling by extending ResponseEntityExceptionHandler

• Created custom annotations for validation

• Configured custom logging using Logback
Answered by AI
Add your answer

Backtracking problem for tree

Q1. High level design of search engine
Ans. 
A search engine is a software system that is designed to search for information on the World Wide Web.
• Crawling: Search engines use web crawlers to discover and index web pages.

• Indexing: The search engine creates an index of the content it finds during crawling.

• Ranking: Algorithms are used to determine the relevance of web pages to a user's query.

• User Interface: A search engine provides a user-friendly interface for use...read more
Answered by AI
Add your answer

Array sliding window

Q1. Java and project
Add your answer

2 HRS Test 3 Questions on Hackerearth