Cognizant Senior System Executive Interview Questions and Answers

There were a total of seven sections: verbal ability, logical reasoning, arithmetic problems, verbal reasoning, puzzles, pseudocodes, and essay writing, with each section having its own cutoff scores.

Q1. What is the SQL query to retrieve the person with the highest salary?
Add your answer
Q2. Can you describe the projects you have worked on?
Add your answer
Q3. Write a query to merge 2 tables?
Add your answer
Q4. Tell me about the internship that you have done?
Add your answer
Q5. Behavioural questions
Add your answer

Q1. Describe microservice architecture for an e-commerce platform
Ans. 
Microservice architecture for e-commerce platform involves breaking down the application into smaller, independent services.
• Each service is responsible for a specific business function, such as inventory management or payment processing.

• Services communicate with each other through APIs, allowing for flexibility and scalability.

• Each service can be developed, deployed, and scaled independently, making it easier to mainta...read more
Answered by AI
Add your answer
Q2. What is the SAGA pattern?
Ans. 
The SAGA pattern is a design pattern used in distributed systems for managing long-lived transactions.
• SAGA pattern breaks down a long transaction into a series of smaller, more manageable transactions.

• Each smaller transaction is executed independently and can be compensated if needed.

• SAGA pattern helps maintain consistency and reliability in distributed systems.

• Example: In an e-commerce system, the SAGA pattern can be ...read more
Answered by AI
Add your answer
Q3. How Apache Kafka can be used to across multiple producers and consumers across Kafka cluster ?
Ans. 
Apache Kafka can be used to enable communication between multiple producers and consumers across a Kafka cluster.
• Producers can publish messages to specific topics in the Kafka cluster.

• Consumers can subscribe to these topics and receive messages in real-time.

• Kafka ensures fault tolerance and scalability by distributing data partitions across multiple brokers.

• Producers and consumers can be distributed across different no...read more
Answered by AI
Add your answer
Q4. Core Java Questions like Streams API, few problems to solve with flat mapping
Add your answer
Q5. Core Spring Boot questions
Add your answer
Q6. DS questions : 2sum problems ,(solve using compliment method), mergesort pseudo code
Add your answer

Q1. Design patterns
Add your answer
Q2. Sql interview questions
Add your answer

Q1. Case study about the given requirement
Add your answer
Q2. Springboot basic questions
Add your answer

First round > General aptitude and versant test.

Q1. How to manage VDI?
Ans. 
VDI can be managed by monitoring performance, updating software, optimizing resources, and ensuring security.
• Monitor performance regularly to identify any issues or bottlenecks.

• Update VDI software and patches to ensure system stability and security.

• Optimize resources by balancing workloads and adjusting configurations as needed.

• Ensure security measures are in place, such as encryption, access controls, and regular back...read more
Answered by AI
Add your answer
Q2. O365 services and it's related questions.
Add your answer
Q3. Questions on cloud computing, cloud services.
Add your answer

Q1. Explain about patch management in Linux
Add your answer
Q2. After patching what are the issues you faced. How did you troubleshoot those issues.
Add your answer

Q1. What is DNS and DNS records
Ans. 
DNS stands for Domain Name System, which translates domain names to IP addresses.
• DNS is like the phone book of the internet, translating human-readable domain names (like google.com) to IP addresses (like 172.217.3.206).

• DNS records are used to store information about a domain, such as the IP address of the server hosting the domain, mail server information, etc.

• Common types of DNS records include A records (for IPv4 ad...read more
Answered by AI
Add your answer
Q2. How to patch esxi
Ans. 
ESXi can be patched using VMware Update Manager, command line interface, or by manually downloading and applying patches.
• Use VMware Update Manager to automate patching process

• Use command line interface to manually apply patches

• Download patches from VMware website and apply manually if needed
Answered by AI
Add your answer

Q1. Why you are leaving your current job
Ans. 
Seeking new challenges and opportunities for growth
• Looking for a new challenge to further develop my skills and knowledge

• Interested in exploring new technologies and projects

• Seeking opportunities for career advancement and growth

• Desire for a change in work environment or company culture
Answered by AI
Add your answer