Universal E Business Solutions Interview Questions and Answers

Q1. Self intro and project architecture
Add your answer
Q2. What are the data sources used?
Add your answer
Q3. Bigquery architecture
Add your answer
Q4. Partition vs clustering
Add your answer
Q5. Bq commands on create table and load csv file
Add your answer
Q6. Bq commands on show the schema of the table
Add your answer
Q7. Explain about leaf nodes and columnar storage.
Add your answer
Q8. How many slots are there in bigquery?
Add your answer

A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8

The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.

Q1. Interviewer was himself not knowing anything as it was walkin drive he was sitting infront of me and checking questions on phone Introduction that he inturrepted in between when I was introducing myself
Add your answer
Q2. What are the features of Java 17, specifically related to sealed classes, including their syntax and necessity, along with the potential errors encountered when invoking a sealed class?
Ans. 
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
• Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.

• Subclasses of a sealed class must be either final or sealed themselves.

• Errors may occur when trying to extend a sealed class with a non-permitted subclass.
Answered by AI
Add your answer
Q3. Java 8 feathers stream api, functional interface, Intermittent operator ,Ternary operator, Prediction,Bi predicate. Answered all successfully
Add your answer
Q4. Draw low level design of implementation of notify me if item is back in stock in a ecommerce application
Ans. 
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
• Create a database table to store user notifications for out-of-stock items

• Implement a service to check item availability and send notifications to subscribed users

• Provide a user interface for users to subscribe to notifications for specific items
Answered by AI
Add your answer
Q5. All design patterns which I know. Asked me to implement adapter pattern on paper
Add your answer
Q6. Then given a problem that concurrent way perform operation on excell to decrease the response time
Add your answer

Q1. What is DHCP and how many type of DHCP and please explain how to work DHCP DORA Process ?
Add your answer
Q2. What is OU and how to configure and Please Explain ADC ?
Add your answer
Q3. What is APIPA and how to work and what is APIPA Range.
Add your answer
Q4. Please explain OSPF and BGP ?
Add your answer
Q5. What is OSI layer and please explain all Layer ?
Add your answer

Q1. How many variance in sap?
Ans. 
The number of variances in SAP can vary depending on the specific processes and transactions being analyzed.
• The number of variances in SAP can be influenced by factors such as data entry errors, system glitches, or discrepancies in invoice processing.

• Variances in SAP may be identified through reconciliation processes, exception reports, or manual reviews of accounts payable transactions.

• Examples of variances in SAP inc...read more
Answered by AI
View 1 more answer
Q2. We cac explain the all accounts receivable and accounts payable
Ans. 
Accounts receivable and accounts payable are two important aspects of a company's financial operations.
• Accounts receivable refers to money owed to a company by its customers for goods or services provided.

• Accounts payable refers to money owed by a company to its suppliers or vendors for goods or services received.

• Accounts receivable is an asset on the balance sheet, while accounts payable is a liability.

• Managing accoun...read more
Answered by AI
View 2 more answers
Q3. What is the cost element and cost center?
Ans. 
Cost element and cost center are key concepts in accounting for tracking and allocating costs within an organization.
• Cost element refers to the specific types of costs incurred by an organization, such as materials, labor, or overhead.

• Cost center is a specific department, team, or function within an organization that is responsible for incurring costs.

• Cost elements are assigned to cost centers to track and allocate cos...read more
Answered by AI
View 2 more answers
Q4. How many we have currencies in sap?
Ans. 
SAP supports over 160 currencies worldwide.
• SAP supports over 160 currencies for global transactions.

• Currencies can be configured in SAP using transaction code OB22.

• Each currency is assigned a unique currency code (e.g. USD for US Dollar, EUR for Euro).
Answered by AI
View 1 more answer
Q5. How many types of projects
Ans. 
There are various types of projects, including internal projects, external projects, research projects, and development projects.
• Internal projects focus on improving processes within the organization.

• External projects involve working with external partners or clients.

• Research projects aim to gather data and analyze findings.

• Development projects focus on creating new products or services.

• Examples: IT system implementati...read more
Answered by AI
View 1 more answer

Q1. Introduce your self
Add your answer
Q2. What are your hobbies
Add your answer
Q3. Explain your family background
Add your answer
Q4. Explain your education background
Add your answer
Q5. Extreme your native place
Add your answer

Q1. Azure cloud platform tech
Add your answer
Q2. Informatica tech stack ques
Add your answer

Q1. Adf tech stack que
Add your answer
Q2. Scd type 2 implementation
Add your answer

Q1. Dw related que ans
Add your answer
Q2. Solution design related que
Add your answer

Q1. Aspiration from my end
Add your answer
Q2. How soon can join
Add your answer

Q1. Linux commands like Cat /etc/os-release
Add your answer
Q2. Aws services like NAT, NACL etc
Add your answer
Q3. Service Assurance
Add your answer
Q4. Monitoring and observability
Add your answer
Q5. Devops principles
Add your answer
Q6. Major Incident lifecycle
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. What has been your experience in each of the companies you have worked for?
Add your answer

Q1. Can you tell me about yourself?
Add your answer
Q2. Could you briefly describe the companies you have worked for?
Add your answer
Q3. What technologies have you worked with, and what was your role in each?
Add your answer
Q4. What are some use case studies related to the technologies you have worked with?
Add your answer

Q1. API Gateway implementation
Ans. 
API Gateway implementation is a centralized service that routes, manages, and secures API calls.
• API Gateway acts as a single entry point for all API calls

• It can handle authentication, rate limiting, caching, and request/response transformations

• Examples include AWS API Gateway, Apigee, Kong
Answered by AI
Add your answer
Q2. Circuit breaker implementation
Ans. 
Circuit breaker is a design pattern used to prevent system overload by temporarily stopping requests to a failing service.
• Circuit breaker monitors requests to a service and opens when the service fails repeatedly.

• It helps prevent cascading failures and allows the system to gracefully degrade.

• Once the circuit breaker is open, it can periodically check if the service has recovered before allowing requests again.
Answered by AI
Add your answer
Q3. What is deadlock? How to avoid it?
Ans. 
Deadlock is a situation in which two or more processes are unable to proceed because each is waiting for the other to release a resource.
• Avoid circular wait by ensuring processes request resources in the same order.

• Prevent hold and wait by requiring processes to request all needed resources at once.

• Implement a timeout mechanism to break potential deadlocks.

• Use resource allocation graphs to detect and prevent deadlocks.

• ...read more
Answered by AI
Add your answer
Q4. Explain equals() method
Ans. 
The equals() method is used to compare the contents of two objects for equality.
• The equals() method is a method of the Object class in Java.

• It is used to compare the contents of two objects for equality.

• The default implementation of equals() in the Object class compares memory addresses, so it is often overridden in custom classes to compare content.

• Example: String class overrides equals() method to compare the content
Answered by AI
Add your answer
Q5. How mongodb was integrated in your application?
Ans. 
MongoDB was integrated in the application by using the official Java driver and configuring connection settings.
• Used the official MongoDB Java driver to interact with the database

• Configured connection settings such as host, port, database name, and authentication credentials

• Implemented CRUD operations using MongoDB Java driver methods

• Utilized MongoDB aggregation framework for complex queries
Answered by AI
Add your answer
Q6. What is hibernate?
Ans. 
Hibernate is an open-source Java framework that simplifies the development of database interactions in Java applications.
• Hibernate is an Object-Relational Mapping (ORM) tool that maps Java objects to database tables.

• It provides a way to perform database operations using Java objects instead of writing SQL queries.

• Hibernate handles the mapping of Java classes to database tables and vice versa, as well as the generation ...read more
Answered by AI
Add your answer
Q7. Runnable vs Callable interface
Ans. 
Runnable is a functional interface with a single run() method, while Callable is a functional interface with a single call() method.
• Runnable is used for tasks that do not return a result, while Callable is used for tasks that return a result.

• Callable can throw checked exceptions, while Runnable cannot.

• Callable returns a Future object, which can be used to retrieve the result of the computation.

• Example: Runnable - execu...read more
Answered by AI
Add your answer
Q8. Which type of data is returned by Callable interface?
Ans. 
The Callable interface in Java returns a Future object.
• Callable interface returns a Future object which represents the result of a computation that may not be available yet.

• The Future object can be used to retrieve the result of the computation, check if it is done, or cancel the computation.

• Example: Callable<Integer> task = () -> { return 42; }
Answered by AI
Add your answer
Q9. HashMap internal working
Add your answer
Q10. Concurrent HashMap internal working
Add your answer
Q11. How to monitor health of your application?
Ans. 
Monitor application health using metrics, logs, alerts, and performance monitoring tools.
• Use monitoring tools like Prometheus, Grafana, or New Relic to track key metrics such as CPU usage, memory usage, response times, and error rates.

• Implement logging to record important events and errors in your application. Use tools like ELK stack (Elasticsearch, Logstash, Kibana) for log analysis.

• Set up alerts to notify you of any...read more
Answered by AI
Add your answer
Q12. How to call an API in a Microservice architecture?
Ans. 
To call an API in a Microservice architecture, use HTTP requests or messaging protocols like gRPC.
• Use HTTP requests to communicate between microservices

• Implement RESTful APIs for easy integration

• Leverage messaging protocols like gRPC for efficient communication

• Consider using service discovery mechanisms for dynamic API calls
Answered by AI
Add your answer
Q13. Explain Profiles
Ans. 
Profiles in Java are configurations that define the capabilities of a Java platform.
• Profiles allow developers to target specific types of devices or applications.

• They help in reducing the size of the Java runtime environment by including only the necessary APIs.

• Examples include Java SE Embedded Profile for embedded devices and Java SE Compact Profile for resource-constrained environments.
Answered by AI
Add your answer
Q14. What is OpenFeign, and how is it used in microservices architecture?
Ans. 
OpenFeign is a declarative web service client used to simplify the process of making HTTP requests in microservices architecture.
• OpenFeign allows developers to define RESTful web services as interfaces and automatically generate the necessary implementation code.

• It integrates seamlessly with Spring Cloud and other microservices frameworks to facilitate communication between services.

• OpenFeign supports features like loa...read more
Answered by AI
Add your answer
Q15. What is the implementation process for service registry and discovery?
Ans. 
Service registry and discovery involves registering services and allowing clients to discover and connect to them.
• Implement a service registry where services can register themselves with metadata

• Use a service discovery mechanism for clients to find and connect to services

• Implement health checks to ensure services are available and healthy

• Use a load balancer to distribute traffic among multiple instances of a service
Answered by AI
Add your answer
Q16. What are Spring boot actuators?
Ans. 
Spring Boot Actuators are built-in tools that provide insight into the running application.
• Actuators expose various endpoints to monitor and manage the application.

• They can be used to check health, metrics, environment details, and more.

• Examples include /actuator/health, /actuator/metrics, and /actuator/env.
Answered by AI
Add your answer
Q17. Synchronous vs Asynchronous communication
Ans. 
Synchronous communication is blocking, while asynchronous communication is non-blocking.
• Synchronous communication waits for a response before continuing, while asynchronous communication does not wait.

• Examples of synchronous communication include traditional function calls, while examples of asynchronous communication include callbacks and promises.

• Synchronous communication can lead to performance issues if there are d...read more
Answered by AI
Add your answer
Q18. Explain Synchronized keyword
Ans. 
Synchronized keyword is used in Java to control access to shared resources by multiple threads.
• Synchronized keyword can be applied to methods or code blocks to ensure only one thread can access the synchronized code at a time.

• It prevents race conditions and ensures thread safety by creating a lock on the object or class.

• Example: synchronized void myMethod() { // synchronized code block }
Answered by AI
Add your answer
Q19. What are the consequences of excessively using synchronized blocks and methods in Java?
Ans. 
Excessive use of synchronized blocks and methods in Java can lead to performance issues and potential deadlocks.
• Decreased performance due to increased contention for locks

• Potential deadlocks if multiple threads are waiting for each other to release locks

• Increased complexity and difficulty in debugging and maintaining code

• Use synchronized sparingly and consider alternatives like ConcurrentHashMap or Lock interface
Answered by AI
Add your answer
Q20. How can you determine the number of threads needed for your application?
Ans. 
The number of threads needed for an application can be determined based on factors like the type of tasks, hardware resources, and performance requirements.
• Consider the type of tasks your application needs to perform - CPU-bound tasks may benefit from more threads, while I/O-bound tasks may not.

• Take into account the hardware resources available - more threads may be beneficial on a multi-core processor compared to a si...read more
Answered by AI
Add your answer
Q21. Explain Executor framework
Ans. 
Executor framework is a framework in Java that provides a way to manage and execute tasks asynchronously.
• Allows for managing thread execution in a more efficient way

• Provides a way to decouple task submission from task execution

• Supports various types of executors like ThreadPoolExecutor and ScheduledExecutorService

• Helps in handling tasks concurrently and asynchronously
Answered by AI
Add your answer
Q22. Explain BlockingQueue
Ans. 
BlockingQueue is an interface in Java that represents a queue which supports operations that wait for the queue to become non-empty when retrieving an element and wait for space to become available in the queue when adding an element.
• BlockingQueue is part of the java.util.concurrent package.

• It is used for implementing producer-consumer scenarios where multiple threads are involved.

• Methods like put() and take() are used...read more
Answered by AI
Add your answer

Q1. Why did you leave your previous company?
Ans. 
Seeking new challenges and opportunities for growth.
• Desire for career advancement

• Looking for new challenges

• Seeking better work-life balance

• Company restructuring or downsizing

• Relocation to a new area
Answered by AI
Add your answer
Q2. Other basic questions asked regarding the relevant skills and technologies I have worked with.
Add your answer