10+ Wipro Architect Interview Questions and Answers

Designing test data content for different flavors of DB

• Identify the data types and structures for each DB flavor

• Create test data that covers all possible scenarios and edge cases

• Ensure data consistency and accuracy across all DB flavors

• Consider performance and scalability factors for distributed DBs

• Include mainframe-specific data such as EBCDIC encoding and packed decimal formats

Yes, I am familiar with Constraint development & coding.

• I have experience in developing constraints for architectural designs to ensure structural integrity and safety.

• I am proficient in coding languages commonly used in architectural software, such as AutoCAD and Revit.

• I have successfully implemented constraints in various projects to meet client requirements and building codes.

I would prefer Ingress in Kubernetes for managing external access to services.

• Ingress provides a way to manage external access to services in a Kubernetes cluster.

• Ingress can provide load balancing, SSL termination, and name-based virtual hosting.

• Ingress allows for more flexibility and control over routing traffic to different services.

• Gateway is more commonly used in the context of API gateways for managing APIs.

• Ingress is a better choice for managing external access to serv...read more

To scale a system to 1 million users, optimize database, use load balancing, and implement caching.

• Optimize database by indexing frequently queried data and partitioning tables

• Use load balancing to distribute traffic across multiple servers

• Implement caching to reduce database queries and improve response time

• Consider using a content delivery network (CDN) to serve static assets

• Use horizontal scaling by adding more servers instead of vertical scaling by upgrading hardware

• Perfo...read more

Yes, I am familiar with * (client name) STA flow.

• Yes, I have experience working with * (client name) STA flow.

• I have successfully implemented * (client name) STA flow in previous projects.

• I am knowledgeable about the specific requirements and processes involved in * (client name) STA flow.

Yes, I have experience with both block-level and subsystem-level STA.

• I have experience with block-level STA, where I focused on timing analysis within a specific block of the design.

• I have also worked on subsystem-level STA, which involves analyzing timing across multiple blocks or components of the design.

• Examples of tools I have used for STA include PrimeTime and Tempus.

New technologies of DBMS are constantly emerging to improve data management and analysis.

• New SQL databases like CockroachDB and TiDB are gaining popularity for their scalability and distributed architecture.

• NoSQL databases like MongoDB and Cassandra are widely used for their flexibility and ability to handle unstructured data.

• Graph databases like Neo4j and OrientDB are becoming popular for their ability to handle complex relationships between data.

• In-memory databases like Red...read more

It depends on the specific requirements of the project. ECS is simpler to set up and manage, while EKS offers more flexibility and control.

• ECS is easier to set up and manage compared to EKS

• EKS offers more flexibility and control over the infrastructure

• Consider the level of control and customization needed for the project

• ECS is a good choice for simpler applications with less complex requirements

• EKS is suitable for more complex applications that require fine-tuning and customi...read more

SQL analytical functions are used to perform calculations across a set of rows in a table.

• They allow for advanced analysis and reporting in SQL queries.

• Examples include functions like RANK(), ROW_NUMBER(), and LEAD().

Design an ecommerce web app

• Include a user-friendly interface for easy navigation

• Integrate a secure payment gateway for transactions

• Provide detailed product descriptions and high-quality images

• Include a search bar and filters for easy product discovery

• Allow customers to create accounts and save their preferences

• Provide customer support through chat or email

• Include a review and rating system for products

• Offer promotions and discounts to incentivize purchases

PL/SQL collections are data structures used to store multiple elements of the same data type in Oracle databases.

• PL/SQL collections include associative arrays, nested tables, and VARRAYs.

• They can be used to store data temporarily during processing.

• Examples include storing employee names in an array or tracking customer orders in a nested table.

Normalization in database is the process of organizing data in a database to reduce redundancy and improve data integrity.

• Normalization involves breaking down a database into smaller, more manageable tables.

• It helps in reducing data redundancy by storing data in a structured manner.

• Normalization ensures data integrity by minimizing data anomalies.

• There are different normal forms such as 1NF, 2NF, 3NF, BCNF, and 4NF.

• For example, in a database of students and courses, instead o...read more

A trigger is a special kind of stored procedure that is automatically executed when certain events occur in a database.

• Triggers are used to maintain referential integrity, enforce business rules, and automate actions in response to data changes.

• They can be defined to execute before or after an INSERT, UPDATE, or DELETE operation on a table.

• For example, a trigger can be set up to automatically update a timestamp column whenever a row is modified in a table.