Wipro Project Architect Interview Questions and Answers

Q1. What is trigger
Ans. 
A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database management system.
• Triggers can be used to enforce business rules, maintain referential integrity, or audit changes to data.

• Examples of triggers include automatically updating a timestamp when a record is modified, preventing deletion of a record based on certain conditions, or sending an email notification w
Answered by AI
Add your answer
Q2. What is dbms and explain all kinds of normalization in oracle
Ans. 
DBMS stands for Database Management System. Normalization in Oracle is the process of organizing data in a database efficiently.
• DBMS is a software that manages databases, allowing users to store, retrieve, and manipulate data.

• Normalization in Oracle involves organizing data into tables and columns to reduce redundancy and improve data integrity.

• There are different levels of normalization, such as First Normal Form (1NF...read more
Answered by AI
Add your answer

Q1. Any papers submitted
Add your answer

Q1. How to handle message related issues via Kubernetes!
Ans. 
Message related issues in Kubernetes can be handled by troubleshooting network configurations, checking pod logs, and monitoring resource usage.
• Troubleshoot network configurations to ensure proper communication between pods

• Check pod logs for any error messages or issues related to message passing

• Monitor resource usage to identify any bottlenecks or performance issues affecting message delivery
Answered by AI
Add your answer

Q1. What is your day to day job as DevOps Engineer?
Add your answer
Q2. How did you create cicd pipelines?
Ans. 
I created CI/CD pipelines using Jenkins and GitLab CI for automated testing and deployment.
• Utilized Jenkins to create pipelines for building, testing, and deploying code

• Integrated GitLab CI for automated testing and deployment processes

• Used Docker containers for consistent environments across different stages

• Implemented version control to track changes and rollback if needed
Answered by AI
Add your answer

Q1. Explain about cloud infra you setup for application deployment
Ans. 
I have set up a scalable cloud infrastructure using AWS for application deployment.
• Utilized AWS services such as EC2, S3, RDS, and Elastic Beanstalk for hosting and managing the application

• Implemented auto-scaling and load balancing to ensure high availability and performance

• Configured security groups, IAM roles, and VPC settings to secure the infrastructure

• Used CloudFormation templates for infrastructure as code to au
Answered by AI
Add your answer
Q2. How did you use terraform to build the infrastructure?
Ans. 
I used Terraform to automate the provisioning and management of infrastructure resources.
• I defined infrastructure as code using Terraform configuration files

• I used Terraform commands to create, update, and destroy infrastructure resources

• I leveraged Terraform modules to reuse and share infrastructure configurations

• I integrated Terraform with version control systems for collaboration and versioning

• I utilized Terraform p...read more
Answered by AI
Add your answer

Q1. Microservices architecture
Add your answer
Q2. Spring boot advantage and disadvantage
Ans. 
Spring Boot provides rapid development and easy configuration, but may have performance overhead.
• Advantage: Rapid development due to auto-configuration and starter dependencies

• Advantage: Simplified deployment process with embedded servers

• Disadvantage: Potential performance overhead due to auto-configuration and runtime dependencies
Answered by AI
Add your answer

Basic situational based question

Q1. Basic experience
Add your answer
Q2. Roles and responsibilities
Add your answer
Q3. Asked my past projects
Add your answer
Q4. Asked behavioral questions
Add your answer
Q5. Asked my salary expectations
Add your answer

Q1. Explain about your experience
Ans. 
I have over 10 years of experience working on various residential and commercial projects, specializing in sustainable design.
• 10+ years of experience in architecture

• Worked on residential and commercial projects

• Specialize in sustainable design
Answered by AI
Add your answer
Q2. Micro services design patterns
Ans. 
Micro services design patterns are architectural patterns used to design and implement microservices-based applications.
• Decompose the application into small, independent services

• Use API gateways for routing and load balancing

• Implement service discovery for dynamic service registration and discovery

• Use circuit breakers for fault tolerance and resilience

• Implement event-driven architecture for communication between servic
Answered by AI
Add your answer

Solution design in data architecture diagram on azure platform

Role as solution architect and presales related questions

Singleton Pattern with coding example class

Q1. Service lifetime
Add your answer
Q2. Shared or static class
Add your answer